Re: MyISAM Performance for fixed row_format

2006-08-30 Thread Chris
Boyd Hemphill wrote: The documentation for 4.1 says that changing to a row_format of fixed will increase disk look up. I did this with several tables where a query was taking about 3 minutes. I expected (from the doc and past experience) for the query to run in about 1 to 1 ½ minutes. Ins

MyISAM Performance for fixed row_format

2006-08-30 Thread Boyd Hemphill
The documentation for 4.1 says that changing to a row_format of fixed will increase disk look up. I did this with several tables where a query was taking about 3 minutes. I expected (from the doc and past experience) for the query to run in about 1 to 1 ½ minutes. Instead it now takes about