drifter Posted December 5, 2006 Share Posted December 5, 2006 I was reading that tables are a lot faster if they are fixed width columns for searches.I have a table with about 150,000 rows, maybe 60 fields. I can easily make them all fixed width except 1 - the description - is a text field. I would have to rewrite that to a new table... join....etc...My question is how much of a speed boost do you really get? That table is populated by 15 data importers from different sources, and I would need to rewrite them all. So I just need to know if the search make a noticable difference. NOTE: all myisam tables.ThanksScott Quote Link to comment Share on other sites More sharing options...
artacus Posted December 5, 2006 Share Posted December 5, 2006 Judging by the silence, I'd say that no one else thinks your performace gains would be noticable either. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 6, 2006 Share Posted December 6, 2006 In general, the performance gain is marginal... but if 99% of the rows don't have descriptions, you may want to consider it later. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.