Hello all,
Just wanted to know how many columns are preferable in table. At present we are
having nearly 50 - 60 columns in some of the tables. Is this ok or should we be
splitting the tables for normalization.
If we really need to split then how better would it be in terms of performance
At 06:32 AM 8/3/2006, Ratheesh K J wrote:
Hello all,
Just wanted to know how many columns are preferable in table. At present
we are having nearly 50 - 60 columns in some of the tables. Is this ok or
should we be splitting the tables for normalization.
If we really need to split then how
I'm not sure what the limit is. MySQL limits tend to be dictated by the
OS that is being used. The more columns you have the larger the database
file will be. You should try to avoid having many empty columns in a
database design, even if you are using varchar instead of char. Try to
think
From: Andrew Kuebler [EMAIL PROTECTED]
2) Is it just as fast with Mysql to access 10 fields in a table with 10
columns as it would be to access those same 10 fields among let's say 90
other fields in a 100 column table?
Are you certain that performance should be your primary concern here?
I
Two questions:
1) How many columns does MySQL support per table?
2) Is it just as fast with Mysql to access 10 fields in a table with 10
columns as it would be to access those same 10 fields among let's say 90
other fields in a 100 column table? Would speed only be reduced if I
pulled a query