[ psqlodbc-Bugs-1010062 ] huge ODBC metadata traffic - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1010062 ] huge ODBC metadata traffic
Date
Msg-id 20071101081058.6B2512170DB@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1010062, was opened at 01/11/2007 08:10
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010062&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Roberto Colmegna (ice72)
Assigned to: Nobody (None)
Summary: huge ODBC metadata traffic

Initial Comment:
Hi,

I have a VB5 app which is connected to a PG 8 via ODBC driver.  I noticed
that I have a lot of meta-data (against sys-tables) traffic generated from
ODBC driver.

Particularly if I redo N times the same query I have N times the metadata traffic (which is about 90% of the total
querytraffic). 

Is there any way to force the ODBC driver to cache this metadata?

TIA

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010062&group_id=1000125

pgsql-odbc by date:

Previous
From: "Dong Calmada"
Date:
Subject: Do we read the same books?
Next
From: "Peter Cai"
Date:
Subject: Is odbc much slower than npgsql?