Re: Two fast queries combined = slow?

2005-11-22 Thread David Hillman
You are the man, Joe. The wall next to my desk thanks you, for stopping me from continuing to beat my head against it. -- David Hillman LiveText, Inc 1.866.LiveText x235 On Nov 22, 2005, at 7:50 PM, Joseph Cochran wrote: Subqueries in 1.4.14 don't use indexes, instead performing full-

Two fast queries combined = slow?

2005-11-22 Thread David Hillman
This makes no sense to me, please explain if you can. I have two queries, both run in under a tenth of a second. But, when one is run as a sub-query of the other, run time is essentially infinite ( I haven't had that much patience, yet ). For example, although these are not the ac