On Mon, Jun 15, 2009 at 3:56 PM, Mike McGrath<mmcgrath(a)redhat.com> wrote:
Is it better to have:
id | smallString1 | smallString2 | smallString3 | largerString1
or put the largerString1 in it's own table? largerString1 I'm
specifically thinking about is for
http://bugzilla.redhat.com/503550
Also, does mysql have a problem with having a table with many columns in
it? Where many== 20, 30, 40?
I'm specifically talking about a table with around 1.2 million rows in it
which is growing at a rate of several hundred thousand rows every 6
months.
-Mike
MySQL's maximum limit is 3398 columns in a table, so I would say
around 30 is OK. I've seen a database with 50 tables and it ran fine.
The max size of a table row is 65534 (BLOB and TEXT not included) - I
don't know what measurement the 65535 is though.
It depends on what you want to do with the data, if you should put it
in a new table or not.
-Anand