Connection Lifetime and pooling

Connection Lifetime and pooling

Postby bradk » Fri 23 Feb 2007 17:41

I'm trying to understand what this means from the docs:

"Connection Lifetime - When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. The default value is 0. "

If the default value is 0, that implies a connection is destroyed every time its returned to the pool. Or, is 0 a special value that means the connection never expires ?

Another pooling question: if I set the max pool size to a smaller value (say 10), will attempts to make more than 10 connections fail, or just not use the pool ?
bradk
 
Posts: 34
Joined: Thu 20 Apr 2006 01:42

Postby Alexey » Mon 26 Feb 2007 08:44

If the default value is 0, that implies a connection is destroyed every time its returned to the pool. Or, is 0 a special value that means the connection never expires ?
It is a special value that means the connection never expires.
if I set the max pool size to a smaller value (say 10), will attempts to make more than 10 connections fail, or just not use the pool ?
The attempt will fail.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL