Re: phpBB2 slow on postgres vs mysql ? - Mailing list pgsql-general

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.