?? wrote: > 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?
"Obsolete" means the entire wiki, which has not been updated for a long time. However, this does not necessarily mean that the information has become wrong. > https://www.sqlite.org/lang_select.html talks about LIMIT & OFFSET, > without mentioning that is a bad idea. Neither does it mention that it is a good idea. > can I do that or not (will it become sluggish if I do that) ? When you use large OFFSET values, the database must compute all these rows before throwing them away. Regards, Clemens
