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" with "UseDeclareFetch=0" does not help.
I still hope there is a way to get RowCount without ReConnecting,
ReSelecting and halve the performance.
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.
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Saito||Date: 2011-07-08 15:38:21|
|Subject: psqlODBC 09.00.0310 Released|
|Previous:||From: Ramesh Reddy||Date: 2011-07-05 17:09:42|
|Subject: Re: RowCount && UseDeclareFetch Performance|