Any DBA's in the house?

Mike McGrath mmcgrath at redhat.com
Mon Jun 15 19:56:42 UTC 2009


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




More information about the Fedora-infrastructure-list mailing list