| From: | "Ken J(dot) Wright" <ken(at)ori-ind(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | Re: [INTERFACES] fetching way too much or too often??? |
| Date: | 1999-06-30 18:30:23 |
| Message-ID: | 3.0.1.32.19990630113023.00ab7b30@ori-ind.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lauri Posti | 1999-06-30 18:39:28 | large objects |
| Previous Message | JT Kirkpatrick | 1999-06-30 18:11:30 | fetching way too much or too often??? |