How To Split Query Up Into Smaller Queries And Run Them One At A Time In Android Sqlite

I have a listview which is supposed to show 25 rows of data but with the images in the database, the query has exceeded 1mb when reach 13 rows and as I quote from here Android SQL

Solution 1:

Use limit and offset to page through the data.