From: Ken J. Wright <ken@ori-ind.com>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] fetching way too much or too often???
Date: Wed, 30 Jun 1999 11:30:23 -0700
Message-ID: <3.0.1.32.19990630113023.00ab7b30@ori-ind.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ken@ori-ind.com
Subject: Re: [INTERFACES] fetching way too much or too often???
In-Reply-To: <3.0.1.32.19990630113023.00ab7b30@ori-ind.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox