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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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