[Zope] Re: kInterbaseDA multiple connection
fg at nuxeo.com
Wed Feb 23 15:23:41 EST 2005
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'.
> 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
More information about the Zope