Понеділок, 9 липня 2012 р. користувач Misa Simic <
misa.simic@gmail.com> написав:
>
>
> 2012/7/9 Gregg Jaskiewicz <
gryzman@gmail.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-value order by key limit N' is much better in performance for large offsets.
p.s. Sorry for previous email- hit send too early.
--
Best regards,
Vitalii Tymchyshyn