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

On Wed, Apr 9, 2008 at 10:56 AM, Hannu Krosing <hannu(at)krosing(dot)net> wrote:
>
> 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?

What version of Npgsql?

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

You can discuss this also in our forums:

forums.npgsql.org

Thanks in advance.

--
Regards,

Francisco Figueiredo Jr.
fxjr.blogspot.com
www.npgsql.org