List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:July 7 2012 5:34am
Subject:Re: Subquery taking too much time on 5.5.18?
View as plain text  
> See "The unbearable slowness of IN()" at
> http://www.artfulsoftware.com/infotree/queries.php


Do you read your own links? Excerpt:

> In 5.0, EXISTS() is much faster than IN(), but slower than JOIN. In 5.5, 
EXISTS() performs about as well as JOIN.

So.... judging by the subject line...
Thread
Subquery taking too much time on 5.5.18?Cabbar Duzayak6 Jul
  • Re: Subquery taking too much time on 5.5.18?Reindl Harald6 Jul
    • RE: Subquery taking too much time on 5.5.18?Benjamin Stillman6 Jul
      • Re: Subquery taking too much time on 5.5.18?Cabbar Duzayak6 Jul
    • RE: Subquery taking too much time on 5.5.18?Rick James16 Jul
  • RE: Subquery taking too much time on 5.5.18?David Lerer6 Jul
    • Re: Subquery taking too much time on 5.5.18?Peter Brawley7 Jul
      • Re: Subquery taking too much time on 5.5.18?Rik Wasmus7 Jul
        • Re: Subquery taking too much time on 5.5.18?Cabbar Duzayak7 Jul
          • Re: Subquery taking too much time on 5.5.18?Peter Brawley7 Jul
            • Re: Subquery taking too much time on 5.5.18?Cabbar Duzayak8 Jul
  • RE: Subquery taking too much time on 5.5.18?Rick James16 Jul