MySQL Forums
Forum List  »  Optimizer & Parser

Re: mysql subquery query optimization question
Posted by: Rick James
Date: January 13, 2013 11:30AM

> Is it some kind of an optimizer issue

Bluntly, Yes.

> is there something I can do from the MySQL side to make the first query as fast as the second one?

Version 5.6.7 (Or MariaDB 5.5) might be addressing it.

The lesson here is that Frameworks (etc) have to drop to the lowest common denominator; sometimes this severely impacts performance. Sometimes they even add complexity.

You seen to understand SELECT statements; can you toss the Framework and do explicit SELECTs?

Options: ReplyQuote

Written By
Re: mysql subquery query optimization question
January 13, 2013 11:30AM

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.