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: 1309893593372-4554370.post@n5.nabble.com (view raw or flat)
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.

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-2014 The PostgreSQL Global Development Group