MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Correlated subquery taking much much longer since upgrade from 5.0
Posted by: Alan Douglas
Date: July 06, 2012 09:34AM

Okay, so it looks like the only options are:

1) rewrite all queries of this type in a half-million lines of code, or
2) stick with MySQL 5.0 indefinitely, or
3) try PostgreSQL (which no doubt opens up other issues)

I'm surprised this hasn't come up elsewhere. "ORDER BY id DESC LIMIT 1" seems a pretty natural way of pulling the most recent record from a set, and having queries jump from seconds to hours is kind of hard to miss.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.