Sencha Touch Sync Store Performance Issue

I am developing application using sencha touch 2. I have one problem using store.sync() its taking too much (about 20 min) time while execution this statement. I have to insert 850

Solution 1:

You are loading all 8500 records first in sencha store then sync store. Instant of directly save data in your local database spare table than load all data in store it will increase your app performance.

Code will you need to change

var db = window.openDatabase("databasename", "1.0", "database", 10000000);
    db.transaction(queryDB, errorCB);
    functionqueryDB(tx) {
        for(indexcnt = 0; indexcnt < record.length; indexcnt++)
        {
           var id = indexcnt+1;
           tx.executeSql(insert query);   //put here your table insert query put here
        }
        spareStore.load();