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

On Wed, 2008-04-09 at 18:33 +0530, Ashish Sharma wrote:
> 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.

You have to give more info than that to get any meaningful advice .

Unless you are just looking for some paid-support guy to contact you ;)

And as this seems to be a .NET related problem, you may get a better
answer from some dedicated list, maybe
http://archives.postgresql.org/pgsql-interfaces/

-------------------------
Hannu