Re: Connection Pooling Problems Dave Page
От | James M Doherty PGADMIN |
---|---|
Тема | Re: Connection Pooling Problems Dave Page |
Дата | |
Msg-id | 008301c519bd$64048ba0$68363c90@ad.tri.sbc.com обсуждение исходный текст |
Ответ на | Connection Pooling Problems ("James M Doherty PGADMIN" <jimmyd@jdoherty.net>) |
Ответы |
Re: Connection Pooling Problems Dave Page
|
Список | pgsql-odbc |
DOES ANYONE HAVE ANY EXPERIENCE WITH THIS .... DAVE PAGE? ANYONE...
Jim
----- Original Message -----From: James M Doherty PGADMINSent: Wednesday, February 16, 2005 12:18 PMSubject: [ODBC] Connection Pooling ProblemsI have an application that uses the ODBC interface from a window XP machine. I have set connection pooling on the pgsql driver to on witha timeout of 120 seconds. This is being called from an Excel spread sheet. When the user refreshes the spread sheet I get hundreds ofconnections 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 likeconnection 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 !JimJames M Doherty
jim@jdoherty.net
Georgetown, TX 78626
"There is no luck without discipline" IRISH PROVERB
Вложения
В списке pgsql-odbc по дате отправления: