Re: Slow statement when using JDBC

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow statement when using JDBC
Дата
Msg-id 4765.1296688815@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Slow statement when using JDBC  (yazan suleiman <yazan.suleiman@gmail.com>)
Список pgsql-jdbc
yazan suleiman <yazan.suleiman@gmail.com> writes:
> I've done more research.  This problem appears at the database level.  I
> excluded JDBC by running explain anaylze on 2 different statement, the first
> is a prepared one  The prepared showed the same behavior.  Please see below:

Try declaring the parameter the same type as the column it's being
compared to (which you didn't mention, but I'm guessing it's NUMERIC).

            regards, tom lane

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

Предыдущее
От: yazan suleiman
Дата:
Сообщение: Re: Slow statement when using JDBC
Следующее
От: "Donald Fraser"
Дата:
Сообщение: Re: Timing of notice delivery