On 27 Feb 2003, Dave Cramer wrote:
> Anyone have any experience with this and why it is slow
No indexes? Or they don't get used?
Or, they do something like:
select field1 from table1 where id=2;
for (i=0;i<countfromselect;i++){
select * from table2 where field2=field1fromabove
}
when a simple subselect or union or whatever would have worked?
Maybe they make a query like this:
select * from table where field1 in (1000 terms);
Hard to say without looking at their code.