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

Browse pgsql-interfaces by date

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