Oracle or PostGreSQL connection pool
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. Miklos Nemeth
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. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
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
On 1/14/00 5:24 AM, Nemeth Miklos at nemeth@iqsoft.hu wrote:
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?
It means when the Connection object is activated, the connection is made, when the object is deactivated, it is closed. This may or may not coincide with other events, and is heavily determined by the aging and size of the cache. I hope this makes more sense. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
participants (2)
-
Christopher Petrilli -
Nemeth Miklos