durusmail: quixote-users: Re: Reusing connections quixote 2
Re: Reusing connections quixote 2
2006-11-07
2006-11-07
2006-11-07
2006-11-07
2006-11-07
2006-11-07
2006-11-08
2007-02-01
2007-02-01
2007-02-01
2006-11-08
2006-11-08
2006-11-08
2006-11-08
2006-11-09
2006-11-08
Re: Reusing connections quixote 2
Michael Watkins
2006-11-08
* 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


reply