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