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

Thanks for the response. Below are the details:

> > On Wed, 2008-04-09 at 18:33 +0530, Ashish Sharma wrote:
> > > Hi,
> > >

> Hi, all!!

> > > 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.
> > >
> > >
>
>
> What queries are you running?

We are running normal SQLs and DMLs. Even simple queries like "select * from..." are showing the described behavior.

> What version of Npgsql?

NPGSQL ver. 1.97.1.0
>
> Are you using prepared statements? We have performance issues with
> prepared statements. If it is so, can you try without prepared
> statements?

We are not you prepared statements.

>
> You can discuss this also in our forums:
>
> forums.npgsql.org
>

The dotNet version we are using is 2.0, PostgreSQL 8.2.4 (on RHEL4)

Appreciate the support.

Regards,
Ashish Sharma

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.11 - Release Date: 4/9/2008 12:00 AM