Re: parameterized query much much slower than one with hard-coded string

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: parameterized query much much slower than one with hard-coded string
Дата
Msg-id CA+0W9LOU1jb=ngTEDY7g5g49RsgR6fd+yGAkahxzBpqBH7n01Q@mail.gmail.com
обсуждение исходный текст
Ответ на parameterized query much much slower than one with hard-coded string  (Timbo Chen <timbo@powerreviews.com>)
Ответы Re: parameterized query much much slower than one with hard-coded string  (Timbo Chen <timbo@powerreviews.com>)
Список pgsql-jdbc
Дерево обсуждения 
On 10 November 2011 17:44, Timbo Chen <timbo@powerreviews.com> wrote:
> what could be the possible reason that these 2 nearly identical queries have
> such different performance?

> different execution plans?

Yes.

> how would i find out what the actual execution
> plan was?

EXPLAIN ANALYZE?

Oliver

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

Предыдущее
От: Timbo Chen
Дата:
Сообщение: parameterized query much much slower than one with hard-coded string
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: parameterized query much much slower than one with hard-coded string