SQLite Forum

Prepared Statements
Login
>Consider using "SELECT <fieldlist> FROM <table> WHERE rowid > ? limit ?" to cater for deletions and return a specific number of rows. This also allows you to set the window size just once.

Sound (forward-looking) advice; thank you.