Optimize Android Database Update (sqlite) From Web Service

Good day. I've constructed an app that has an SQLite database that retrieves its contents from a JSON service pre-populated using MySQL. Every day, there is an update, a minor name

Solution 1:

You can try this : Just make one DBHandler class and write one function to insert the items into that table with necessary parameters. and one delete method to delete all previous records from table.

Whenever you get a updated data then reinsert all data into that table.

This is one of the solution that i am currently using.

check this : To update table for every 2 minutes