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

Reply via email to