Re: Connection pool issues with clsql

On Tue, 2 Feb 2010, Mackram Raydan wrote:

> Date: Tue, 2 Feb 2010 23:40:23 +0200
> From: Mackram Raydan <[email protected]>
> To: clsql <[email protected]>
> Subject: [CLSQL] Connection pool issues with clsql
> 
> Hey everyone,
>
> I am attempting to use the clsql in a production enviroment that is running
> Ubuntu 9.04 server edition (64 bit). In order to have good performance I am
> attempting to use a pool of connections however I am faced with the problem
> that every time I attempt to do a connection disconnect to return the thread
> to the pool I get an error and the whole thing crashes. Without pooling the
> system runs fine. Any one faced such a thing before?
>
> Any help is much appreciated.
>
> Regards,
>
> Mackram Raydan
>
> Company: www.imagimate.com
> Website: www.trailoflight.net
>
> "An invasion of armies can be resisted, but not an idea whose time has
> come." Victor Hugo

I may have run into this a long time ago, if memory serves. It was too
long ago to be relevant today (I hope). Anyway, I abandoned connection
pooling, and adopted the methodology of opening a connection at the
beginning of a request, using that connection for the lifetime of the
request, and closing it at the end. Things run fast if you avoid
opening and closing connections during a transaction (I use the word
"transaction" loosely here to mean "all the stuff that happens during
one user operation, or request").

Carlos