SQL fast in PSQL, very slow using MS.NET driver

From: "Ashish Sharma" <ashish(at)coredbsystems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: SQL fast in PSQL, very slow using MS.NET driver
Date: 2008-04-09 09:43:16
Message-ID: 001b01c89a26$24dac150$6e9043f0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-04-09 10:03:53 Re: select statement fails
Previous Message ludwig 2008-04-09 09:35:35 Re: Trouble with foreign key