connection pooling in web apps

Поиск
Список
Период
Сортировка
От Ottavio Campana
Тема connection pooling in web apps
Дата
Msg-id 4FE02F98.8050605@campana.vi.it
обсуждение исходный текст
Ответы Re: connection pooling in web apps  (Ottavio Campana <ottavio@campana.vi.it>)
Re: connection pooling in web apps  (Nicolas Grilly <nicolas@gardentechno.com>)
Список psycopg
Hi,

I am developing some apps with pyramid and I am having performance
problems.

I really suspect that the issue is the fact that I am not using a
persistent connection to the database, thus for each query I have to
reconnect to the db.

In the paste, I used to develop on zope, which handled automatically the
connections to the db. Now I am using my custom methods on pyramid (not
sqlalchemy).

Do you have a link to some documentation, that explain how to use
connection pooling in wsgi apps? I was thinking about using pgpool-II
but this does not solve the problem that I reconnect every time to the db.

Thanks,

Ottavio

--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.

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

Предыдущее
От: Bill House
Дата:
Сообщение: Re: Capacity questions
Следующее
От: Ottavio Campana
Дата:
Сообщение: Re: connection pooling in web apps