Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5F3832E004F for ; Wed, 9 Apr 2008 05:15:58 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 04095-03 for ; Wed, 9 Apr 2008 05:15:51 -0300 (ADT) X-Greylist: delayed 00:06:26.19753 by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by developer.postgresql.org (Postfix) with ESMTP id DFB102E0047 for ; Wed, 9 Apr 2008 05:15:54 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so959876nfh.23 for ; Wed, 09 Apr 2008 01:15:53 -0700 (PDT) Received: by 10.78.152.17 with SMTP id z17mr15194030hud.63.1207728566612; Wed, 09 Apr 2008 01:09:26 -0700 (PDT) Received: from CDSPN02 ( [220.224.225.179]) by mx.google.com with ESMTPS id d27sm17252571nfh.2.2008.04.09.01.09.24 (version=SSLv3 cipher=RC4-MD5); Wed, 09 Apr 2008 01:09:25 -0700 (PDT) Reply-To: From: "Ashish Sharma" To: Subject: SQL fast in PSQL, very slow using MS.NET driver Date: Wed, 9 Apr 2008 13:40:55 +0530 Organization: Core Database Systems Pvt. Ltd. Message-ID: <000001c89a19$40c98e30$c25caa90$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C89A47.5A81CA30" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AciaGTvqgejlVO7iRm6dFEtl4zrIuA== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200804/85 X-Sequence-Number: 28849 This is a multipart message in MIME format. ------=_NextPart_000_0001_01C89A47.5A81CA30 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: 7bit Hi, The setup in question includes PostGRESQL v8.2.4, Java based web servers and MS.NET based web servers. Following is the fuzzy situation: 1. Our SQL queries run very fast using PSQL (both, from the server as well as the client). 2. The Java app also retrieves the results very fast (of course, we are using Postgres JDBC driver). 3. But, the same SQL queries perform pathetically slow when called from .NET application. The driver being used is NPGSQL. I have tried making some alterations to TCP related system variables like TCP_NoDelay and TCPAckFrequency on Windows, but to no profit. Same setup is already running on Oracle backend, and, there is no difference in SQL response timings from either application. Please advice, as this has become a major hurdle for us to push PostGRESQL to be productionized, in place of currently running Oracle DB. Regards, Ashish Sharma Core Database Systems HYPERLINK "http://www.coredbsystems.com"http://www.coredbsystems.com No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: 4/2/2008 4:14 PM ------=_NextPart_000_0001_01C89A47.5A81CA30 Content-Type: text/html; charset="windows-1250" Content-Transfer-Encoding: quoted-printable

Hi,

The setup in question includes PostGRESQL v8.2.4, = Java based web servers and MS.NET based web servers. Following is the fuzzy = situation:

1.       Our SQL queries run very fast using PSQL (both, = from the server as well as the client).

2.       The Java app also retrieves the results very = fast (of course, we are using Postgres JDBC driver).

3.       But, the same SQL queries perform pathetically = slow when called from .NET application. The driver being used is = NPGSQL.

 

I have tried  making some alterations to TCP = related system variables like TCP_NoDelay and TCPAckFrequency on Windows, but to = no profit. Same setup is already running on Oracle backend, and, there is = no difference in SQL response timings from either = application.

 

Please advice, as this has become a major hurdle = for us to push PostGRESQL to be productionized, in place of currently running = Oracle DB.

 

Regards,

 

Ashish Sharma

Core Database Systems

http://www.coredbsystems.com

 

 


No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: = 4/2/2008 4:14 PM

------=_NextPart_000_0001_01C89A47.5A81CA30--