Re: how many args to SELECT...IN()

[Thimble Smith]

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