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.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
