Re: Large tables, ORDER BY and sequence/index scans

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Large tables, ORDER BY and sequence/index scans
Дата
Msg-id 2f4958ff1001050538h37ddd660m5f973d25e28a4221@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Large tables, ORDER BY and sequence/index scans  (Milan Zamazal <pdm@brailcom.org>)
Ответы Re: Large tables, ORDER BY and sequence/index scans  (Milan Zamazal <pdm@brailcom.org>)
Список pgsql-general
2010/1/5 Milan Zamazal <pdm@brailcom.org>:

> Cursors are very convenient for me, because they allow easy browsing
> data in the user interface (fetching limited sets of rows while seeking
> forward and backward) and they prevent contingent seeking and other
> troubles when concurrent updates happen.
>

Sounds to me like a borked app design. Do you seriously need to walk
the user through couple of million rows of data ?

I mean, databases are designed to work on data, and give you the
result back. Use this capability intelligently.


--
GJ

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Large tables, ORDER BY and sequence/index scans
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Large tables, ORDER BY and sequence/index scans