[mod_python] Persistent db connections

Conrad Steenberg conrad at hep.caltech.edu
Thu Aug 7 10:51:01 EST 2003

Hi Van

You're right, I confused dbpool (python) with dbpool (java) which does
what I described.

If you can provide a DB connection limit >= the Apache connection limit
you should probably be fine. 

>From python the SqlRelay also does what I described (allow many more
connections to the DB than the DB connection limit). See
http://sqlrelay.sourceforge.net/ and esp.



On Thu, 2003-08-07 at 10:17, VanL wrote:
> Conrad Steenberg wrote:
> >Using dbpool would make your web app fail more gracefully, i.e. get
> >slower with more connections, instead of giving some users an error that
> >it was unable to connect to the DB, as you often see on overloaded
> >discussion sites.
> >
> Is this correct?  I thought that even dbpool would not pool resources 
> between different apache processes.  Thus having a 
> one-connection-per-process (or two, or three, but some fixed number) 
> rule along with an apache maxclients setting would tend to keep the 
> database connections within an acceptable range.
> If the max number of clients could be known, regardless of the number of 
> apache child processes, that would be great.  However, that doesn't 
> match my understanding of how it works.
> VanL
Conrad Steenberg <conrad at hep.caltech.edu>

More information about the Mod_python mailing list