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@xxxxxxxxxxx>
To: Divakar Singh <dpsmails@xxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
Sent: Thu, December 9, 2010 10:31:17 AM
Subject: Re: 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@xxxxxxxxxxx --
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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?
Divakar
From: Alex Goncharov <alex-goncharov@xxxxxxxxxxx>
To: Divakar Singh <dpsmails@xxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
Sent: Thu, December 9, 2010 10:31:17 AM
Subject: Re: 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@xxxxxxxxxxx --
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
