android - pagination in listview

Question

Thanks in advance.

I am developing a Car Review Application, where user can log in and displayed all the review from the Database. All the the data is being stored in MYSQLdatabase first. I am using json to connect to the MYSQLdatabase and SQLiteDatabase. But the problem is that, after log in the application screen huge no. of data is coming from the server and it is being inserted in our SQLite Database.

After that it is being retrieved from database and displayed in the Application Screen in a list view, it is taking a longer time to displayed all the data in list view. In that case, I am using a SimpleCursorAdapter to retrieve all the data from database.

So is there any way like pagination or something like that to make the data retrieval faster. Please help me by giving some source code.

Answer 1

You can use something like:

• Page 1:

  SELECT * FROM YOUR_TABLE LIMIT 20 OFFSET 0
  

• Page 2:

  SELECT * FROM YOUR_TABLE LIMIT 20 OFFSET 20
  

Reference: http://sqlite.org/lang_select.html