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

Re: LabView and PostgreSQL ; and RecordSet GetString performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: smacedo(at)calmetric(dot)pt
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: LabView and PostgreSQL ; and RecordSet GetString performance
Date: 2005-08-25 04:22:24
Message-ID: 24046.1124943744@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
"Silvio Macedo" <smacedo(at)calmetric(dot)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

In response to

pgsql-interfaces by date

Next:From: Greg Sabino MullaneDate: 2005-08-25 17:06:27
Subject: Re: DBD::Pg and "invalid frontend message type 10"
Previous:From: Silvio MacedoDate: 2005-08-25 03:59:40
Subject: LabView and PostgreSQL ; and RecordSet GetString performance

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