From: Ashish Sharma <ashish@coredbsystems.com>
To: pgsql-admin@postgresql.org
Subject: SQL fast in PSQL, very slow using MS.NET driver
Date: Wed, 9 Apr 2008 13:40:55 +0530
Message-ID: <000001c89a19$40c98e30$c25caa90$@com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ashish@coredbsystems.com
Subject: Re: SQL fast in PSQL, very slow using MS.NET driver
In-Reply-To: <000001c89a19$40c98e30$c25caa90$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox