Apache + PHP + Postgres Interaction
От | Max Zorloff |
---|---|
Тема | Apache + PHP + Postgres Interaction |
Дата | |
Msg-id | op.txixw2k8ll0p5y@1-rtt202dnf3uds.mshome.net обсуждение исходный текст |
Ответы |
Re: Apache + PHP + Postgres Interaction
|
Список | pgsql-general |
Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a connection to the Postgres database through pg_pconnect(). Then it runs some query, then the script returns, leaving the persistent connection hanging. But the trouble is that in this case any query takes significantly more time to execute than in the case of one PHP script running the same query with different parameters for N times. How can I achieve the same performance in the first case? Persistent connections help but not enough - the queries are still 10 times slower than they would be on the 2nd time. The second one is that the machine with this setup is dual core Xeon 2.8ghz. I've read somewhere about the switching context problem and bad postgres performance. What are the effects? What are the symptoms? And what will be the performance gain if I change the machine to equal Athlon? Thank you in advance.
В списке pgsql-general по дате отправления: