| From: | BGoebel <b(dot)goebel(at)prisma-computer(dot)de> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: RowCount && UseDeclareFetch Performance |
| Date: | 2011-07-05 19:19:53 |
| Message-ID: | 1309893593372-4554370.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Saito | 2011-07-08 15:38:21 | psqlODBC 09.00.0310 Released |
| Previous Message | Ramesh Reddy | 2011-07-05 17:09:42 | Re: RowCount && UseDeclareFetch Performance |