Message-Id: <3.0.1.32.19990630113023.00ab7b30@ori-ind.com>
Date: Wed, 30 Jun 1999 11:30:23 -0700
To: pgsql-interfaces@postgreSQL.org
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: Re: [INTERFACES] fetching way too much or too often???
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 14:11 06/30/1999 -0400, you wrote:
>we have about 20 folks linked to a postgres 6.4.2 database through 
>msaccess97 and the latest odbc driver.  we have declare/fetch turned on. 
> we are having a problem with the database locking up often!  i am trying 
>to eliminate the possibilities / theories, and i am on the declare/fetch 
>process now.
>
>when a user selects one record, as a watch on the debug window (started 
>postmaster w/ debug 3), it is processing many (25-50?  who can count that 
>fast??) fetch 100's -- but they only selected one record from one table! 
> why so many fetch 100's??  should i turn off declare / fetch on everyone's 
>odbc??

YES! turn it off!

I think that was before Byron had the cursor library included. It has
little to no value at this point.

Ken