From: | "James M Doherty PGADMIN" <jimmyd(at)jdoherty(dot)net> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Connection Pooling Problems Dave Page |
Date: | 2005-02-23 15:36:06 |
Message-ID: | 008301c519bd$64048ba0$68363c90@ad.tri.sbc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
DOES ANYONE HAVE ANY EXPERIENCE WITH THIS .... DAVE PAGE? ANYONE...
Jim
----- Original Message -----
From: James M Doherty PGADMIN
To: pgsql-odbc(at)postgresql(dot)org
Sent: Wednesday, February 16, 2005 12:18 PM
Subject: [ODBC] Connection Pooling Problems
I have an application that uses the ODBC interface from a window XP machine. I have set connection pooling on the pgsql driver to on with
a timeout of 120 seconds. This is being called from an Excel spread sheet. When the user refreshes the spread sheet I get hundreds of
connections logged in /var/log/messages from the user. There are about 200 queries which try to execute at close to the same time.
As a temporary measure I have increased the number of simultaneous connections to 500 to support this, however it does not look like
connection pooling is working correctly. Any ideas on how I might diagnose this, or is there a known fix for this type of problem.
I am running 7.4 and 7.03.01.00 of the ODBC driver.
Thanks for any help you can give me !
Jim
James M Doherty
jim(at)jdoherty(dot)net
Georgetown, TX 78626
"There is no luck without discipline" IRISH PROVERB
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2005-02-23 16:11:45 | Re: Connection Pooling Problems Dave Page |
Previous Message | Ramon Danieli | 2005-02-23 09:40:32 | Re: ODBCVER > 0x0250 |