Обсуждение: Prefetching results

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
odbcdriver there is a no_cache and forward_cursor connection setting preventing this behaviour.
 

regards,
Honza Prochazka

j.prochazka@rare-technologies.com 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