[Zope] Oracle or PostGreSQL connection pool

Nemeth Miklos nemeth@iqsoft.hu
Fri, 14 Jan 2000 11:24:14 +0100


Christopher Petrilli wrote:

> On 1/13/00 3:57 PM, Nemeth Miklos at nemeth@iqsoft.hu wrote:
>
> > Do the Oracle or PostgreSQL database adapters and the ZSQL technology
> > support connection pooling?
> > If I create a connection object, supposedly it may only be used by a
> > single thread.
> > I'd like to use ZSQL methods but my application should be very
> > concurrent.
>
> There will exist no more connections than there are applicaton threads.
> Requests are pooled through applicaton threads, so you will see that form of
> pooling.

Does that mean, that when an application thread is started a new connection is
established (in the case of Oracle with a olog() call), and when the thread is
about to finish the connection is closed (ologof())?
Is it possible to pre-start (similar to what Apache does when pre-forking child
processes) Zope application threads?

NM