Re: Database connection caching

2005-03-19 Thread lbolognini
Thanks everybody for their replies. Lorenzo -- http://mail.python.org/mailman/listinfo/python-list

Re: Database connection caching

2005-03-18 Thread Istvan Albert
[EMAIL PROTECTED] wrote: Hi all, is there an alternative way of: - create a connection object - open the connection - close the connection psycopg, a Postgresql database adapter does connection pooling automatically http://initd.org/projects/psycopg1 Most Zope database adapters also have implicit c

Re: Database connection caching

2005-03-18 Thread Simon Brunning
On 18 Mar 2005 04:52:03 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > is there an alternative way of: > > - create a connection object > - open the connection > - close the connection > > every time one has to run a query. It's actually morte like: create connection create cursor execut

Re: Database connection caching

2005-03-18 Thread Skip Montanaro
Lorenzo> is there an alternative way of: Lorenzo> - create a connection object Lorenzo> - open the connection Lorenzo> - close the connection Lorenzo> every time one has to run a query. Sure, create a Queue.Queue object and stuff a number of connections into it. When you wan

Re: Database connection caching

2005-03-18 Thread Swaroop C H
On 18 Mar 2005 04:52:03 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi all, > > is there an alternative way of: > > - create a connection object > - open the connection > - close the connection > > every time one has to run a query. Why not use cursor objects with a single connection

Database connection caching

2005-03-18 Thread lbolognini
Hi all, is there an alternative way of: - create a connection object - open the connection - close the connection every time one has to run a query. I assume that big sites do something to prevent the performance hit given by these operations, don't they? Would you kindly point me to some exam