From: Divakar Singh <dpsmails@yahoo.com>
To: Alex Goncharov <alex-goncharov@comcast.net>
Cc: alex-goncharov@comcast.net
Cc: pgsql-performance@postgresql.org
Subject: Re: libpq vs ODBC
Date: Wed, 8 Dec 2010 22:39:36 -0800 (PST)
Message-ID: <957894.71040.qm@web65406.mail.ac4.yahoo.com> (raw)
In-Reply-To: <E1PQZPa-0000yV-Pd@hanssachs.home>
References: <772237.64789.qm@web65408.mail.ac4.yahoo.com>
<E1PQYd3-0000wW-PB@hanssachs.home>
<254429.23607.qm@web65410.mail.ac4.yahoo.com>
<E1PQZPa-0000yV-Pd@hanssachs.home>
hmm
If I understand it correctly you argument is valid from performance point of
view.
But in practical scenarios, it would make more sense to do ODBC if the
difference is only 5% or so, because it opens up so many choices of databases
for me.
Do we have some published data in this area.
Best Regards,
Divakar
________________________________
From: Alex Goncharov <alex-goncharov@comcast.net>
To: Divakar Singh <dpsmails@yahoo.com>
Cc: alex-goncharov@comcast.net; pgsql-performance@postgresql.org
Sent: Thu, December 9, 2010 11:21:26 AM
Subject: Re: [PERFORM] libpq vs ODBC
,--- You/Divakar (Wed, 8 Dec 2010 21:17:22 -0800 (PST)) ----*
| 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.
You can't say a "visible impact" unless you can measure it in your
specific application.
Let's say ODBC takes 10 times of .001 sec for libpq. Is this a
"visible impact"?
| 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?
You've got to measure -- there are too many variables to give you the
answer you are trying to get.
To a different question, "Would I use ODBC to work with PostgreSQL if
I had the option of using libpq?", I'd certainly answer, "No".
You'd need to have the option of using libpq, though. ODBC takes care
of a lot of difficult details for you, and libpq's higher performance
may turn out to be a loss for you, in your specific situation.
-- Alex -- alex-goncharov@comcast.net --
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dpsmails@yahoo.com, alex-goncharov@comcast.net
Subject: Re: libpq vs ODBC
In-Reply-To: <957894.71040.qm@web65406.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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