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