Database connection pooling with mod_wsgi help?

Cherrypy-noob <[email protected]> Wed, 8 Feb 2017 02:56:33 -0800 (PST)
Newsgroups gmane.comp.python.cherrypy
Message-ID <[email protected]>
Hi All,

new to cherrypy and a bit confused on how to deal with database connection 
pooling under mod_wsgi especially coming from Java world where this is a 
non-issue. Please don't just provide me links, I've read them and they do 
not answer my questions.

For example
http://tools.cherrypy.org/wiki/Databases

and the example does not help.

Correct me if I'm wrong but this won't work. It is not a connection pool. 
On each request, a new connection needs to be made and hence requiring some 
time. In my case the issue is latency. I want a fast response and opening a 
connection on request has a user perceptible impact. What I want is 
connections (eg a a connection pool) that persist over requests and eah 
request can take an already open connection from that pool.

But my understanding of mod_wsgi seems lacking? As far as I can tell it 
shutdowns everything after each request. Thats why for example file based 
cherrypy sessions are need and above databases example does not work. See 

https://groups.google.com/forum/#!topic/cherrypy-users/_gq-mv3aZ1o

This users seems to have the same issue. I have not found a single example 
using a connection pool with mod_wsgi and cherrypy. Is this even possible?

-- 
You received this message because you are subscribed to the Google Groups "cherrypy-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cherrypy-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
To post to this group, send email to cherrypy-users-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
Visit this group at https://groups.google.com/group/cherrypy-users.
For more options, visit https://groups.google.com/d/optout.