List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 6 1999 3:14am
Subject:Re: how many args to SELECT...IN()
View as plain text  
At 19:39, 19990805, Joel Bremson wrote:
>If I didn't see it myself I'd agree with you. Faking the sub query speeds the
>query up significantly. I should also add that the query is more complex
>than the examples.

Joel, I don't mean to get away from the original question, but perhaps
there's a way to speed up the join with better indexes, etc.  Maybe if
you gave a full description of the actual query and the tables involved
(including the output of EXPLAIN for the query), we might find what is
slowing it up.

Tim
Thread
how many args to SELECT...IN()Joel Bremson6 Aug
Re: how many args to SELECT...IN()Paradox6 Aug
  • Re: how many args to SELECT...IN()Thimble Smith6 Aug
Re: how many args to SELECT...IN()Paradox6 Aug
  • Re: how many args to SELECT...IN()Joel Bremson6 Aug
    • Problem reading tablesPaul McGovern6 Aug
    • Re: how many args to SELECT...IN()Thimble Smith6 Aug
      • Re: how many args to SELECT...IN()Alok K. Dhir6 Aug
        • Re: how many args to SELECT...IN()Paradox6 Aug
          • Re: how many args to SELECT...IN()Michael Widenius6 Aug
        • Re: how many args to SELECT...IN()Christian Mack6 Aug
  • Re: how many args to SELECT...IN()Scott Hess6 Aug
    • Re: how many args to SELECT...IN()Joel Bremson6 Aug