[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