Re: Reusing connections quixote 2

Michael Watkins <[email protected]> Wed, 8 Nov 2006 08:47:04 -0800
Newsgroups gmane.comp.web.quixote.user
Message-ID <[email protected]>
* Arturo FM wrote [2006-11-08 16:33:39 +0000]:
> In my view I have three options: a) Use one connection for each process and
> write a cron job for restart my application each 6 hours.  b) Use a
> connection pool (SQLAlchemy) with 'pool_recycle'.  c) Write a class with a
> method where I ask to pool for a connection database, execute a query and
> return the connection to pool. Each query must use this method..

While its not elegant, (a) is just a few seconds work. If your application
can stand that, why not?

-- deja vu-ingly yours, mw