Synchronization from server and inserting in to Sqlite database is very slow


#1

Hey there actually am working on an application which retrieve data from api and store in Sqlite database and then using the sqlite SELECT statement i list them on pages. It works smoothly on 100 to 200 records but when i tried to retrieve 1000’s of records it gets very slow. When i open the page it takes time to load the data. Is there any suggestions to improve the performance of loading.