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

On Thu, Apr 10, 2008 at 5:27 AM, Ashish Sharma <ashish@coredbsystems.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