[Zope] Re: MySQL thread connection question

[Dennis Allison]

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 at 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 )
>