| From: | Kroh István <istvan(dot)kroh(at)pomme(dot)hu> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Fw: odbc/ado problems |
| Date: | 2004-09-01 09:04:52 |
| Message-ID: | 006601c49002$be54a850$0102a8c0@pomme001 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
hi,
i don't think this would be my problem. I tried to set cursor type to
forwardOnly, but the query is so slow as before. Inbetween i checked the
postgres debug traces and i found that after my query some other was runned
with sequential scans and other slow operations.
steve
> ----- Original Message -----
> From: "Markus Donath" <md-postgres-donath(at)netapps(dot)de>
>
>
> > hello,
> >
> > did you use a read only / forward only cursor (adOpenForwardOnly) ?
> > this is the fastest way to retreive data, other cursor types are much
> slower
> > with postgres odbc.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2004-09-02 10:46:02 | Re: odbc/ado problems |
| Previous Message | Markus Donath | 2004-09-01 08:19:48 | Re: odbc/ado problems |