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@netapps.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.
>