pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedLabView and PostgreSQL ; and RecordSet GetString performance
2+ messages / 2 participants
[nested] [flat]
* LabView and PostgreSQL ; and RecordSet GetString performance
@ 2005-08-25 03:59 Silvio Macedo <smacedo@calmetric.pt>
2005-08-25 04:22 ` Re: LabView and PostgreSQL ; and RecordSet GetString performance Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Silvio Macedo @ 2005-08-25 03:59 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
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:
For ODBC:
DRIVER={PostgreSQL};SERVER=127.0.0.1;port=5432;DATABASE=IT2CalMeter200
5;UID=IT2CalMeter;PWD=xxxxx;
For OLEDB:
Provider=PostgreSQL; Location=IT2CalMeter2005; User ID=IT2CalMeter;
Password=xxxxx;
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
ODBC?
Any tips? Any special connection string tuning?
Would GetRows be much better?
Thanks a lot
Silvio
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: LabView and PostgreSQL ; and RecordSet GetString performance
2005-08-25 03:59 LabView and PostgreSQL ; and RecordSet GetString performance Silvio Macedo <smacedo@calmetric.pt>
@ 2005-08-25 04:22 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-08-25 04:22 UTC (permalink / raw)
To: smacedo@calmetric.pt; +Cc: pgsql-interfaces
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-08-25 04:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-25 03:59 LabView and PostgreSQL ; and RecordSet GetString performance Silvio Macedo <smacedo@calmetric.pt>
2005-08-25 04:22 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox