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.