From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: fetching way too much or too often???
Date: Wed, 30 Jun 1999 14:11:30 -0400
Message-ID: <01BEC302.75459D40.jt-kirkpatrick@mpsllc.com> (raw)
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??
thanks! jt
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: jt-kirkpatrick@mpsllc.com, pgsql-interfaces@hub.org
Subject: Re: fetching way too much or too often???
In-Reply-To: <01BEC302.75459D40.jt-kirkpatrick@mpsllc.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