Antimon wrote:
> Just noticed,
> On windows, these results are produced.
> But on linux, postgresql performs great. So postgre has a bad windows
> integration than mysql. Well since it supports win32 for a long time,
> it makes sense.
> I did some "multi client" tests and postgre could not even catch mysql
> so i decided to go test it on my linux box. It seems that the
> performance issue is about windows version.
Part of the problem may be the connection penalty on Windows. Since
PostgreSQL is a processed based database (mySQL is threaded I believe)
it is expensive (resource wise) to fire a bunch of connections.
You may be able to get similar performance if you were to use pconnect
or connection pooling with PHP and PostgreSQL.
Sincerely,
Joshua D. Drake
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: 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
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/