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

On Thu, Apr 10, 2008 at 5:27 AM, Ashish Sharma <ashish(at)coredbsystems(dot)com> wrote:
> Thanks for the response. Below are the details:
>
> >
> > 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
>

No performance problem with it. But it may be good to update to our
latest beta3 release.

> >
> > 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.
>

Ok.

>
> >
> > 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.
>

You are welcome.

Please, when using forums, give us what queries you are running so we
can make some tests to see what can be happening.

Thanks in advance, Ashish.

--
Regards,

Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org