Has Query optimizer improved in 5.4/5.5?

Date: Thu, 04 Mar 2010 12:09:38 -0600
From: mos <mos99@xxxxxxxxxxx>
Subject: Has Query optimizer improved in 5.4/5.5?

I am using MySQL 5.1.30 (MyISAM) and the query optimizer is quite bad atchoosing 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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx

Follow-Ups:
- Re: Has Query optimizer improved in 5.4/5.5?
  - From: Peter Brawley

Prev by Date: Re: 5.1.44 community version select ordno>=' ' error (2)
Next by Date: Re: Has Query optimizer improved in 5.4/5.5?
Previous by thread: Re: 5.1.44 community version select ordno>=' ' error (2)
Next by thread: Re: Has Query optimizer improved in 5.4/5.5?
Index(es):
- Date
- Thread