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 8 minutes!
After running the alter table statements and verifying that the
row_format was indeed "fixed" I then analyzed, optimized and checked
(medium) all tables in the database.
Is there an explanation for why the query time has increase
(dramatically) rather than decreased?
Thank you for your time.
Boyd Hemphill
