| List: | General Discussion | « Previous MessageNext Message » | |
| From: | mos | Date: | March 4 2010 7: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? | mos | 4 Mar 2010 |
| • Re: Has Query optimizer improved in 5.4/5.5? | Peter Brawley | 4 Mar 2010 |