| From: | Віталій Тимчишин <tivv00(at)gmail(dot)com> |
|---|---|
| To: | Misa Simic <misa(dot)simic(at)gmail(dot)com> |
| Cc: | Gregg Jaskiewicz <gryzman(at)gmail(dot)com>, Hermann Matthes <hermann(dot)matthes(at)web(dot)de>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Paged Query |
| Date: | 2012-07-11 08:15:38 |
| Message-ID: | CABWW-d1KRtPWnDOh8M0vYrcHbfJ+vCnkM9UBgOoMAgGSXZH6wQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Понеділок, 9 липня 2012 р. користувач Misa Simic <misa(dot)simic(at)gmail(dot)com>
написав:
>
>
> 2012/7/9 Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
>>
>> Use cursors.
>> By far the most flexible. offset/limit have their down sides.
>
>
> Well, I am not aware what down sides there are in LIMIT OFFSET what does
not exist in any other solutions for paged queries...
where key > last-previous-key order by key
--
Best regards,
Vitalii Tymchyshyn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Віталій Тимчишин | 2012-07-11 08:23:01 | Re: Paged Query |
| Previous Message | Yan Chunlu | 2012-07-11 06:24:24 | Re: how could select id=xx so slow? |