Perhaps it is because the developers of phpbb build their software with
mysql in mind.
So any "smart trick" for mysql is used, any "smart trick" in postgresql
isn't?
Using postgresql as a drop-in replacement for mysql is of course a major
mistake, one does need to redesign the database-model if necessary (at
least check whether it suits) and remodel the logic around the queries
and the queries themselves.
Anyway, please do define what you mean with "slow".
Is it that phpbb runs a fraction slower or multiple times?
Regards,
Arjen
> -----Oorspronkelijk bericht-----
> Van: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] Namens Dave Cramer
> Verzonden: donderdag 27 februari 2003 18:49
> Aan: pgsql-general@postgresql.org
> Onderwerp: [GENERAL] phpBB2 slow on postgres vs mysql ?
>
>
> Anyone have any experience with this and why it is slow
>
>
> --
> Dave Cramer <dave@fastcrypt.com>
> Cramer Consulting
> --
> Dave Cramer <Dave@micro-automation.net>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo@postgresql.org so that your message can get through
> to the mailing list cleanly
>