A week or two ago, Fisher Ulrich asked this list about interfaces from
LabView to PostgreSQL. (hope he's reading as I couldn't find his
original email in the list archive).
For LabView on Windows, you can use LabSQL, which is a simple, but
convenient, ADO wrapper to Postgres. You then can use native OLEDB
(undergoing development) or PostgreSQL OLE/ODBC driver.
LabSQL - google search it
OLEDB and ODBC come with standard dist (windows, of course)
To save you time, DSN-less connection strings are as follows:
Provider=PostgreSQL; Location=IT2CalMeter2005; User ID=IT2CalMeter;
change db, user and pass as needed, obviously.
Now, I'm having two issues with these:
- in native OLEDB, if an error happens when executing an SQL
statement, I cannot close the connection (ADO Connection.Close won't
actually close it) and the backend will start to have lots of zombie
connections (well, Idle at least).
- 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
Any tips? Any special connection string tuning?
Would GetRows be much better?
Thanks a lot
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2005-08-25 04:22:24|
|Subject: Re: LabView and PostgreSQL ; and RecordSet GetString performance |
|Previous:||From: Scott Cain||Date: 2005-08-24 15:30:30|
|Subject: Re: DBD::Pg and "invalid frontend message type 10"|