MySQL Forums
Forum List  »  Optimizer & Parser

Re: Querying a fast subquery never returns
Posted by: Rick James
Date: May 26, 2012 10:59AM

MariaDB 5.5 (released) has and MySQL 5.6.5 (not yet released) will have several significant optimization improvements. There is some overlap of what use cases they tackle well.

I have not heard that VIEWs are being improved. VIEWs are seen more as syntactic sugar, than as an important feature.

> found a related bug reported in 2007
Reference, please.

> this pervasive bug
"pervasive"?

> you can't trust MySQL being able to handle fairly simple queries.
Very true for subqueries. Usually converting to a JOIN is the solution. (Which is "simpler", a JOIN or a subquery?)

I will be happy to help you find workarounds, if you provide the requested information.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Querying a fast subquery never returns
1381
May 26, 2012 10:59AM


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.