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

[ psqlodbc-Bugs-1010062 ] huge ODBC metadata traffic

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010062 ] huge ODBC metadata traffic
Date: 2007-11-01 08:10:58
Message-ID: 20071101081058.6B2512170DB@pgfoundry.org (view raw or flat)
Thread:
Lists: 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 query traffic).

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

Next:From: Peter CaiDate: 2007-11-05 16:24:41
Subject: Is odbc much slower than npgsql?
Previous:From: Dong CalmadaDate: 2007-10-24 03:17:04
Subject: Do we read the same books?

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