From: | Divakar Singh <dpsmails(at)yahoo(dot)com> |
---|---|
To: | Alex Goncharov <alex-goncharov(at)comcast(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: libpq vs ODBC |
Date: | 2010-12-09 05:17:22 |
Message-ID: | 254429.23607.qm@web65410.mail.ac4.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
So it means there will be visible impact if the nature of DB interaction is DB
insert/select. We do that mostly in my app.
Performance difference would be negligible if the query is server intensive
where execution time is far more than time taken by e.g. communication interface
or transaction handling.
Am I right?
Best Regards,
Divakar
________________________________
From: Alex Goncharov <alex-goncharov(at)comcast(dot)net>
To: Divakar Singh <dpsmails(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Sent: Thu, December 9, 2010 10:31:17 AM
Subject: Re: [PERFORM] libpq vs ODBC
,--- You/Divakar (Wed, 8 Dec 2010 20:31:30 -0800 (PST)) ----*
| Is there any performance penalty when I use ODBC library vs using libpq?
In general, yes.
In degenerate cases when most of the work happens in the server, no.
You need to measure in the contents of your specific application.
-- Alex -- alex-goncharov(at)comcast(dot)net --
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-12-09 05:28:52 | Re: Slow BLOBs restoring |
Previous Message | mark | 2010-12-09 05:17:18 | Re: Hardware recommendations |