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.
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?
Not sure about that part of the question, the better one to ask is how
you improve the query in the first place.
Post the query and an explain of the query and see if anyone has any
suggestions about that..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
