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 <[email protected]> To: Divakar Singh <[email protected]> Cc: [email protected] 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 -- [email protected] -- -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
