Skip site navigation (1) Skip section navigation (2)

connection pooling in web apps

From: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
To: psycopg(at)postgresql(dot)org
Subject: connection pooling in web apps
Date: 2012-06-19 07:51:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: psycopg

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

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

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.



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


psycopg by date

Next:From: Ottavio CampanaDate: 2012-06-19 11:15:38
Subject: Re: connection pooling in web apps
Previous:From: Bill HouseDate: 2012-06-19 02:23:46
Subject: Re: Capacity questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group