Many thanks for your message + help.
I have made some tests, which exactly confirm your information. Seeing
things a bit clearer now. The prepared statement you suggested not has made
a big difference, but i will have that in mind.
Conclusion: To limit memory usage, execution time and bandwidth with large
result sets (Columns X Rows) i HAVE to use "UseDeclareFetch=1" and
"Fetch=xxx".
"Fetch=xxx" with "UseDeclareFetch=0" does not help.
I still hope there is a way to get RowCount without ReConnecting,
ReSelecting and halve the performance.
regards
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/RowCount-UseDeclareFetch-Performance-tp4553904p4554370.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.