[mod_python] connection pool (newbie question)

chase3 at llnl.gov wrote ..
> I've looked at connection pool code for a persistent database
> connection.   I don't know where to create the connection pool.
> If in the handler code (I'm using publisher), wouldn't a new
> pool be created each time the handler is called?
> In doing a test, I think the web server is prefork MPM.

For a bit of light reading, check out:

  http://www.dscpl.com.au/articles/modpython-004.html

This will give a bit of context in respect of to what degree global data
is shared when different Apache process modules are used.

Also, read through the past mailing list threads on resource initialisation.
Start with the following entry points and go back and forth through the
discussion.

  http://www.modpython.org/pipermail/mod_python/2005-September/019092.html
  http://www.modpython.org/pipermail/mod_python/2005-October/019287.html

I'll have to review the past messages myself to try and work out what
might be most relevant and whether it does actually cover what you
might need to know, but it is a starting point.

Graham