Tres Seaver <tseaver@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@nuxeo.com