Re: Suspending SELECTs

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: Suspending SELECTs
Дата
Msg-id 43CE0589.3000003@wildenhain.de
обсуждение исходный текст
Ответ на Re: Suspending SELECTs  (Alessandro Baretta <a.baretta@barettadeit.com>)
Список pgsql-performance
Alessandro Baretta schrieb:
> mark@mark.mielke.cc wrote:
>
...
>
> It looks like this is the only possible solution at present--and in the
> future, too--but it has a tremendouse performance impact on queries
> returning thousands of rows.
>
Well actually one of the better solutions would be persistent cursors
(and therefore connection pooling). I bet this is easier then
fiddling with the problems of offset/limit and inventing even more
compex caching in the application.

Just my 0.02c
++Tino

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

Предыдущее
От: Alessandro Baretta
Дата:
Сообщение: Re: Suspending SELECTs
Следующее
От: Alessandro Baretta
Дата:
Сообщение: Re: Suspending SELECTs