Re: slow pg_connect()

Поиск
Список
Период
Сортировка
От vincent
Тема Re: slow pg_connect()
Дата
Msg-id 24238.194.109.235.253.1206347744.squirrel@webmail.xs4all.nl
обсуждение исходный текст
Ответ на slow pg_connect()  (<firerox@centrum.cz>)
Список pgsql-performance
>
> It takes more then 0.05s :(
>
> Only this function reduce server speed max to 20request per second.

First, benchmarking using only PHP is not very accurate, you're probably
also measuring some work that PHP needs to do just to get started in the
first place.

Second, this 20r/s is not requests/sec but connections per second per PHP
script. One pageview in PHP needs one connection, so it will delay the
pageview by 0.05 seconds.

If you need raw speed, you can use pg_pconnect(), but be VERY carefull
because that will keep one databaseconnection open for every database for
every webserverprocess. If you have 10 databasedriven websites running on
the same webserver and that server is configured to run 100 processes at
the same time, you will get 10x100=1000 open connections, which eats more
RAM than you have.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: slow pg_connect()
Следующее
От: "petchimuthu lingam"
Дата:
Сообщение: increasing shared buffer slow downs query performance.