Postgres Pro
Downloads
Home   >   mailing lists

Re: LabView and PostgreSQL ; and RecordSet GetString performance - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: LabView and PostgreSQL ; and RecordSet GetString performance
Date
Msg-id 24046.1124943744@sss.pgh.pa.us
Whole thread Raw
In response to LabView and PostgreSQL ; and RecordSet GetString performance  ("Silvio Macedo" <smacedo@calmetric.pt>)
List pgsql-interfaces
Tree view 
"Silvio Macedo" <smacedo@calmetric.pt> writes:
> - on the other hand, in OLE/ODBC, RecordSet.GetString is about 10
> times slower than native OLEDB to get 20K records (tstamp,value). 

> Anybody had this sort of performance hit on GetString on PostgreSQL
> ODBC?
> Any tips? Any special connection string tuning?

No idea about this myself --- but if you don't get any answers here,
please try the specialized pgsql-odbc list.
        regards, tom lane

pgsql-interfaces by date:

Previous
From: "Silvio Macedo"
Date:
Subject: LabView and PostgreSQL ; and RecordSet GetString performance
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: DBD::Pg and "invalid frontend message type 10"