List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:March 4 2010 6:58pm
Subject:Re: Has Query optimizer improved in 5.4/5.5?
View as plain text  
Mike,

 > Has the query optiimizer improved any for  later MySQL versions?

Have a look at http://dev.mysql.com/tech-resources/articles/mysql-54.html.

Peter Brawley
http://www.artfulsoftware.com

-----

mos wrote:
> 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
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.435 / Virus Database: 271.1.1/2721 - Release Date: 03/03/10 19:34:00
>
>   

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