Skip site navigation (1) Skip section navigation (2)

Re: RowCount && UseDeclareFetch Performance

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: (view raw, whole thread or download thread mbox)
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" 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:
Sent from the PostgreSQL - odbc mailing list archive at

In response to

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2011-07-08 15:38:21
Subject: psqlODBC 09.00.0310 Released
Previous:From: Ramesh ReddyDate: 2011-07-05 17:09:42
Subject: Re: RowCount && UseDeclareFetch Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group