Two things...
1. Exactly how much is too much for a MySQL DB? I'm talking about size. Would something on the lines of 50,000 rows each with 100 fields (most VarChar(10)) be out of line for MySQL?
2. Does the size of the fields effect the search times? Would an example like the following be of faster speed?
DB
===
id place
-- ----
1 3
2 3
3 1
PHP
===
if place = 1 then print New York
if place = 2 then print Chicago
if place = 3 then print Orlando
I was thinking it would be faster because MySQL is processing way less info (just the one-diget numbers), and then the PHP converts them over to usable info.
1. Exactly how much is too much for a MySQL DB? I'm talking about size. Would something on the lines of 50,000 rows each with 100 fields (most VarChar(10)) be out of line for MySQL?
2. Does the size of the fields effect the search times? Would an example like the following be of faster speed?
DB
===
id place
-- ----
1 3
2 3
3 1
PHP
===
if place = 1 then print New York
if place = 2 then print Chicago
if place = 3 then print Orlando
I was thinking it would be faster because MySQL is processing way less info (just the one-diget numbers), and then the PHP converts them over to usable info.