fetching way too much or too often???

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org>
Subject: fetching way too much or too often???
Date: 1999-06-30 18:11:30
Message-ID: 01BEC302.75459D40.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ken J. Wright 1999-06-30 18:30:23 Re: [INTERFACES] fetching way too much or too often???
Previous Message Ken J. Wright 1999-06-30 16:42:09 Re: [INTERFACES] Reply-To: missing