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 Link to comment https://forums.phpfreaks.com/topic/29484-fixed-width-columns/ 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. Link to comment https://forums.phpfreaks.com/topic/29484-fixed-width-columns/#findComment-135700 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. Link to comment https://forums.phpfreaks.com/topic/29484-fixed-width-columns/#findComment-135961 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.