If you are going to be needing to add columns and/or tables, you should
probably rethink your data model.
I'm not sure what data you are tracking, but perhaps you can
consolidate it a bit more. Make your columns into rows with a row type
field. A simple example would be tracking phone numbers.
Hello,
I have a table where misc data are stored. Right now this table has
about 30 columns, but for sure it will be more in the near future. So I
wonder how the big number (50-100) of table's columns affect for MySQL
DB performance. Maybe it's better to create more tables rather than more
table's