Here(http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor) said "Do not try to implement a scrolling window using LIMIT and OFFSET. Doing so will become sluggish as the user scrolls down toward the bottom of the list.?. But the page also said "This information is obsolete? https://www.sqlite.org/lang_select.html talks about LIMIT & OFFSET, without mentioning that is a bad idea. So my question is can I do that or not (will it become sluggish if I do that) ?
Thanks Qiulang