Re: Slow count(*) again...

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Slow count(*) again...
Дата
Msg-id 4CB422C102000025000367F7@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Slow count(*) again...  (Neil Whelchel <neil.whelchel@gmail.com>)
Список pgsql-performance
Neil Whelchel <neil.whelchel@gmail.com> wrote:

> What is the best method to make a page of results and a list of
> links to other pages of results?

For our most heavily used web app we decided to have the renderer
just read the list of cases and render the pages to disk, and then
present the first one.  We set a limit of 500 entries on the list;
if we get past 500 we put up a page telling them to refine their
search criteria.  That won't work for all circumstances, but it
works well for out web app.

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow count(*) again...
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: Slow count(*) again...