Skip site navigation (1) Skip section navigation (2)

Re: Connection Pooling Problems Dave Page

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: James M Doherty PGADMIN <jimmyd(at)jdoherty(dot)net>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection Pooling Problems Dave Page
Date: 2005-02-23 20:24:08
Message-ID: 20050223202408.33500.qmail@web20822.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- James M Doherty PGADMIN <jimmyd(at)jdoherty(dot)net>
wrote:

> 
> Since there are cells in EXCEL each containing a
> query, The server gets hit 
> with a connection request per query. This
> in turn originally exceeded the maximum connections
> supported by my 
> configuration on the server. I raised the number of
> connections supported to 500, however this seems
> like a work around which 
> may resurface again soon.

You might want to rethink your design.  Using
something like ADO, it's fairly easy to get your data
in a single query, and assign the values to cells
however you want.

> 
> I have verified that POOLING is turned on in the
> ODBC driver from the 
> ODBC-ADMIN tool.
> 
> I am looking for ideas on how to further determine
> what is actually not 
> working. Is it something in the driver ? or Is it
> something to do with
> EXCEL's handling of queries.
> 
> Jim
> 
> ----- Original Message ----- 
> From: "Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com>
> To: "James M Doherty PGADMIN" <jimmyd(at)jdoherty(dot)net>;
> 
> <pgsql-odbc(at)postgresql(dot)org>
> Sent: Wednesday, February 23, 2005 10:11 AM
> Subject: Re: [ODBC] Connection Pooling Problems Dave
> Page
> 
> 
> > --- James M Doherty PGADMIN <jimmyd(at)jdoherty(dot)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(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
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail - now with 250MB free storage. Learn
> more.
> > http://info.mail.yahoo.com/mail_250
> > 
> 
> 



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail

In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2005-02-23 21:15:06
Subject: New snapshot - 08.00.0005
Previous:From: Joost KraaijeveldDate: 2005-02-23 17:35:19
Subject: Re: Bug in ODBC driver 08.00.0004 and stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group