[Zope-DB] How to do analysis? (was Re: Saga continues...)

Matthew T. Kromer matt at zope.com
Mon Oct 27 13:47:43 EST 2003

Chris Withers wrote:

> Matthew T. Kromer wrote:
>> Likewise, I hate wasting connections to the DB.  Four Zope threads 
>> can over time establish four Oracle connections, when the likelyhood 
>> is that only one or two connections are needed.  For customers that 
>> pay Oracle on a per-connection basis, using up extra licensed 
>> connections is a bad thing.  Furthermore, a central monitor can have 
>> a better notion of what connections are established and could act to 
>> set up or tear down connections (ie to implement a connection timeout 
>> in Zope).
> Hmmm... interesting, how would you implement this?
> Chris

I'd probably use a module level global with a thread lock and a 
transaction registered thingy that requested context to be managed from 
the module globals.

Thingy is a technical term.

Matt Kromer
Zope Corporation  http://www.zope.com/ 

More information about the Zope-DB mailing list