Re: [PERFORM] libpq vs ODBC

2010-12-09 Thread Pierre C
On Thu, 09 Dec 2010 06:51:26 +0100, Alex Goncharov wrote: ,--- 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

Re: [PERFORM] libpq vs ODBC

2010-12-08 Thread Pavel Stehule
t; 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 a

Re: [PERFORM] libpq vs ODBC

2010-12-08 Thread Divakar Singh
. Best Regards, Divakar From: Alex Goncharov To: Divakar Singh Cc: alex-goncha...@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

Re: [PERFORM] libpq vs ODBC

2010-12-08 Thread Alex Goncharov
,--- 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 ta

Re: [PERFORM] libpq vs ODBC

2010-12-08 Thread Divakar Singh
handling. Am I right? Best Regards, Divakar From: Alex Goncharov To: Divakar Singh 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

Re: [PERFORM] libpq vs ODBC

2010-12-08 Thread Alex Goncharov
,--- 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. -- Ale

[PERFORM] libpq vs ODBC

2010-12-08 Thread Divakar Singh
Is there any performance penalty when I use ODBC library vs using libpq? Best Regards, Divakar