[Zope] Re: kInterbaseDA multiple connection

[Florent Guillaume]

Tres Seaver  <tseaver at zope.com> wrote:
> |  > Each application server thread in your application holds a separate
> |  > instance of the adapter, which means that unless the adapter is coded
> |  > (which I doubt) to multiplex requests from separate instances across a
> |  > single, global connection, you could see as many connections as you
> |  > have appserver threads.
> |
> | Does it mean that number of active connections can grow even more due to
> | thread count growth? Will it decrease when the thread stops?
> 
> By default, Zope is configured to run with four appserver threads (see
> the 'zserver-threads' option in zope.conf).  I misspoke slightly in my
> first post:  the DA connection is actually held inside a database
> connection, of which there are seven by default (the 'connection-pool'
> zope.conf parameter controls this).

I think you mean 'pool-size', not 'connection-pool'.

Florent

> Normally, an appserver thread acquires a connection at the start of the
> request, and the returns it to the pool of available connections.  So,
> the absolute maximum number of open DA connections is the number of ZODB
> database connections in the pool (7), while the "likely" high number is
> lower, depending on your usage patterns (4 if all 4 appserver threads
> stay busy, and use the DA).

-- 
Florent Guillaume, Nuxeo (Paris, France)   CTO, Director of R&D
+33 1 40 33 71 59   http://nuxeo.com   fg at nuxeo.com