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
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 |