MySQL Forums
Forum List  »  Performance

Re: Slow performance when using LIMIT 1000
Posted by: Øystein Grøvlen
Date: February 26, 2015 04:13AM

Hi Christian,

This looks like an optimizer bug to me. Please, file a bug, preferable with a reproducible test case, so we can look into this. If it is difficult to make a test case that can reproduce this, it would be very usefule for us to have the optimizer trace for the query. See http://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html for how to generate this.

As a work-around you can try is to use FORCE INDEX. That is,
"... FROM GroupCall FORCE INDEX(CallInitiated,CallBegin) ... "

Thanks,

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow performance when using LIMIT 1000
713
February 26, 2015 04:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.