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. I've confirmed with echo = True under paster that is does indeed reuse the same connection. netstat also confirms that the paster instance only ever opens 2 connections. tcp 0 0 10.1.1.79:52171 10.0.0.5:1521 ESTABLISHED 17655/python tcp 0 0 10.1.1.79:52170 10.0.0.5:1521 ESTABLISHED 17655/python --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
