WebSQL Multiple Insertion

WebSQL Multiple Insertion.js

// Multiples INSERTs : 2500ms
// Using BEGIN and COMMIT : 90ms
// Using SELECT and UNION : 40ms

var newQuery = true, query = '';
for (i=0; i<locations_length; i++) {
    if (newQuery) {
        query = 'INSERT INTO myTable (id, name, code)';
        newQuery = false;
    }
    else {
        query += ' UNION';
    }
 
    query += ' SELECT "'+values[i][0]+'", "'+values[i][1]+'", "'+values[i][2]+'"';
 
    if (i!=0 && i%499==0) {
        db.execute(query);
        newQuery = true;
    }
}
 
//executing remaining lines
if (i%499!=0) {
    db.execute(query);
}