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

Поиск
Список
Период
Сортировка
От Francisco Figueiredo Jr.
Тема Re: SQL fast in PSQL, very slow using MS.NET driver
Дата
Msg-id 438d02260804101009p6312a5d5r4777d1bbb56165b6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL fast in PSQL, very slow using MS.NET driver  ("Ashish Sharma" <ashish@coredbsystems.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Chernow
Дата:
Сообщение: Re: [PATCHES] libpq type system 0.9a
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index AM change proposals, redux