Re: Connection Pooling Problems Dave Page

--- James M Doherty PGADMIN <jimmyd@jdoherty.net>
wrote:

>
> DOES ANYONE HAVE ANY EXPERIENCE WITH THIS .... DAVE
> PAGE? ANYONE...

More information would be good.  Relevant code,
relevant extracts from log files.  What is the
application actually doing, when the problem occurs?

>
> Jim
>
>
>   ----- Original Message -----
>   From: James M Doherty PGADMIN
>   To: pgsql-odbc@postgresql.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@jdoherty.net
>   Georgetown, TX 78626
>   "There is no luck without discipline" IRISH
PROVERB




__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250