[Zope-DB] ZPsycopgDA Connections and Refreshed Zope Products

Federico Sevilla III jijo@free.net.ph
Sun, 23 Mar 2003 11:14:59 +0800

Hi Dieter,

On Sat, Mar 22, 2003 at 10:20:59PM +0100, Dieter Maurer wrote:
> Usually, Zope's DA instances open a connection as soon they are loaded
> into memory (from ZODB). When the instance is flushed from cache, the
> connection should be closed again.

Ok. Thank you for shedding light on this matter. :)

> The ZODB maintains a pool of connections, each with its own private
> cache. Each cache can hold a (copy of) the DA instance, each with its
> database connection.  The default number of connections is 7 although
> the number of threads is an upper bound if it is smaller.

Hmm... I wonder what explains the ~70 connections I had to the same
database with the same user (based on how things are set up now, that
means exactly one DA). Anyway, I will continue to observe things
especially when I am not refreshing my product anymore. I hope things
work well post-development. :)

 --> Jijo

Federico Sevilla III  : http://jijo.free.net.ph      : When we speak of free
Network Administrator : The Leather Collection, Inc. : software we refer to
GnuPG Key ID          : 0x93B746BE                   : freedom, not price.