List:General Discussion« Previous MessageNext Message »
From:mos Date:March 4 2010 6:09pm
Subject:Has Query optimizer improved in 5.4/5.5?
View as plain text  
I am using MySQL 5.1.30 (MyISAM) and the query optimizer is quite bad at 
choosing the proper index.

I often have to force it to use the correct index for Select statements, 
otherwise takes 50x to 100x slower than it should be.
Has the query optiimizer improved any for  later MySQL versions?
TIA

Mike

Thread
Has Query optimizer improved in 5.4/5.5?mos4 Mar
  • Re: Has Query optimizer improved in 5.4/5.5?Peter Brawley4 Mar