On Sep 30, 10:35 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Sep 30, 10:31 am, Wayne Witzel <[EMAIL PROTECTED]> wrote: > > > > > Is connection pooling with SQLAlchemy under Pylons supported when > > running under mod_wsgi? Is there some special magic to get it working? > > > I have the following INI settings. > > > sqlalchemy.default.pool_size = 1 > > sqlalchemy.diary.pool_size = 1 > > > sqlalchemy.default.max_overflow = 0 > > sqlalchemy.diary.max_overflow = 0 > > > This works fine when running under paster. I only ever get 2 open > > connections to the Oracle database, one for each schema. When I use > > this exact same INI and run my Pylons app under Apache and mod_wsgi it > > seems to ignore these settings and opens a new connection everytime I > > refresh the page. It is always pairs and matches the number of > > refreshes I do. Refresh 7 times, end up with 14 .. etc. > > this is most likely due to the presence of individual subprocesses > within your apache process. Settings like MinSpareServers and > MaxClients in your http.conf will affect this behavior. Take a look > at your process listing and you'll see individual entries for each > httpd process.
Makes sense and now i clearly see the pattern of 2 connections per thread. Thanks for clearing that up. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
