Re: phpBB2 slow on postgres vs mysql ?

Well, I'm just responding to someones request to convert over to mysql,
I don't use the product myself. If anyone has any experience with it,
please speak out.

Dave
On Fri, 2003-02-28 at 15:22, scott.marlowe wrote:
> 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.
--
Dave Cramer <Dave(at)micro-automation(dot)net>