Re: Apache::DBI patch to disconnect idle connections

2004-08-27 Thread Perrin Harkins
On Fri, 2004-08-27 at 13:28, J Robert Ray wrote: > That's an excellent point, but we currently can't take that approach. > Not every app is as well behaved has Apache::DBI. ;) They all can be if you just s/DBI->connect/DBI->connect_cached/g; And really, what app needs to hold a live but unused

Re: Apache::DBI patch to disconnect idle connections

2004-08-27 Thread J Robert Ray
Perrin Harkins wrote: J Robert Ray wrote: What I want from connection pooling is to cache database connections for a relatively short period of time, such as while a user is actively clicking around a web application. Once that user leaves the application, ideally the database connections would

Re: Apache::DBI patch to disconnect idle connections

2004-08-26 Thread Perrin Harkins
J Robert Ray wrote: What I want from connection pooling is to cache database connections for a relatively short period of time, such as while a user is actively clicking around a web application. Once that user leaves the application, ideally the database connections would expire. You might hav

Apache::DBI patch to disconnect idle connections

2004-08-26 Thread J Robert Ray
This patch changes the behavior of Apache::DBI so that it no longer holds onto connections for as long as the httpd child lives. Brief background: I am working to keep the total connection count to our database as low as possible. Apache::DBI tends to accumulate database connections over time,