How many columns can i use in a MySQL table? I'll need approx. 200 records that i access using PHP. Can i have, say, 30 fields (text and varchar) in one record without problems, or should i keep it simple for the sake of better performance?
oP.
that should be no problem until you get into the millions of records you may see some performance issues and think about using more than one table, but until then one table with 30 records isn't a problem
