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

Best cache setting?

From: Patrick Hatcher <PHatcher(at)macys(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Best cache setting?
Date: 2007-02-11 18:39:17
Message-ID: OFC62B8F8F.E25DFC92-ON8825727F.00666813-8825727F.00667D2C@FDS.com (view raw or flat)
Thread:
Lists: pgsql-odbc
ODBC v:8.2

My queries routinely return 10K+ rows of data.  What would be the best
cache setting I can use to get the best throughput?  I have Declare/Fetch
set with a cache default of 100.  Should I turn off Declare/Fetch?

Thank you.

Patrick Hatcher

pgsql-odbc by date

Next:From: noreplyDate: 2007-02-12 19:32:06
Subject: [ psqlodbc-Bugs-1001906 ] Unable to obtain list of tables from the datasource
Previous:From: Ezequias Rodrigues da RochaDate: 2007-02-10 22:52:05
Subject: Creating a System DataSource dinamically

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