Re: working around lack of subselects

2003-02-09 Thread Andy Smith
On Thu, Feb 06, 2003 at 09:52:11AM -0500, Brent Baisley wrote: > As long as the foreign keys are index it should be pretty quick. There > really is no way to get around processing every record in table "data". > As that table grows, your query will get slower. But a 157K rows isn't > really a wh

Re: working around lack of subselects

2003-02-07 Thread Brent Baisley
As long as the foreign keys are index it should be pretty quick. There really is no way to get around processing every record in table "data". As that table grows, your query will get slower. But a 157K rows isn't really a whole lot. How long does it take? Obviously you would want to run SELECT