Prefetching results

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Prefetching results

j.prochazka
Hello,

is there a way to use postgresql-odbc without prefetching statement results? For instance when executing SELECT * FROM table, whole table gets cached into driver memory before fetching any results by an application. In mysql and oracle odbc driver there is a no_cache and forward_cursor connection setting preventing this behaviour.

regards,
Honza Prochazka
Reply | Threaded
Open this post in threaded view
|

Re: Prefetching results

Clemens Ladisch
[hidden email] wrote:
> is there a way to use postgresql-odbc without prefetching statement results?

You probably want to enable the "Use Declare/Fetch" option:
https://odbc.postgresql.org/docs/config.html


Regards,
Clemens