Re: libpq vs ODBC
От
Divakar Singh
Тема
Re: libpq vs ODBC
Дата
Msg-id
254429.23607.qm@web65410.mail.ac4.yahoo.com
Ответ на
Re: libpq vs ODBC (Alex Goncharov)
Список
Дерево обсуждения
libpq vs ODBC Divakar Singh <dpsmails@yahoo.com>
Re: libpq vs ODBC Alex Goncharov <alex-goncharov@comcast.net>
Re: libpq vs ODBC Divakar Singh <dpsmails@yahoo.com>
Re: libpq vs ODBC Alex Goncharov <alex-goncharov@comcast.net>
Re: libpq vs ODBC Divakar Singh <dpsmails@yahoo.com>
Re: libpq vs ODBC Pavel Stehule <pavel.stehule@gmail.com>
Re: libpq vs ODBC "Pierre C" <lists@peufeu.com>
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@comcast.net>
To: Divakar Singh <dpsmails@yahoo.com>
Cc: pgsql-performance@postgresql.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@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
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@comcast.net>
To: Divakar Singh <dpsmails@yahoo.com>
Cc: pgsql-performance@postgresql.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@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
В списке pgsql-performance по дате отправления
