Понеділок, 9 липня 2012 р. користувач Misa Simic <misa.si...@gmail.com> написав: > > > 2012/7/9 Gregg Jaskiewicz <gryz...@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
