In one of the systems we run we have O(150) static MySQL connections only 20 or so of which are active at any given time. We keep the number of connections low by changing databases with almost every query. Currently we have the connection limit set to O(200) to give us a little headroom. The number of connections is important as it multiples the per thread buffer requirements. +1 for making the adaptor pool connections, etc. +1 for migration into the core. On Fri, 13 Aug 2004, Chris Withers wrote:
Andy Dustman wrote:
I would say, it works like most DA's, i.e. ZMySQLDA doesn't add any connection pooling features itself. I suspect you should have one connection per Zope thread (after a sufficient number of requests).
Waaaagh!
*sigh*
I'm starting to feel like I should see about migrating the changes I made for ZOracleDA into the ZOpe core and have all DA's use that way of doing things...
What do people think?
Chris
-- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )