ansaurus

Question

How to speed up the process when inserting 1000's of records into sqlite using HTML5

Answer 1

+1 A:

You're starting 1000 transactions. Committing a transaction is slow because it is linked to hard drive speed. See this

Benoit 2010-10-14 11:56:01

I want any ideas from you.

Neeraja 2010-10-14 12:55:55

Put all your `INSERT`s into the same transaction. That's all!

Benoit 2010-10-14 13:04:47

I didn't get you. Please modify the above code and send it to me.

Neeraja 2010-10-15 05:04:28

Answer 2

A:

You already have the code to place your 1000 inserts inside a single transaction. For some reason it is commented out. Remove the comments and you are done!

db.transaction(function(tx){tx.executeSql("BEGIN",[]);});
for(var i=0;i<1000;i++)
{
    txquer(i,"test");
}
db.transaction(function(tx){tx.executeSql("COMMIT",[]);});

ravenspoint 2010-10-15 11:36:49

Answer 3

A:

Hi,

I put the code for BEGIN,COMMIT but no use. That's why i am commented. Remove the comments also inserting rows into database is very slow. This is the reason I asked how to speed up the process.

Neeraja 2010-10-18 04:14:26

Answer 4

+2 A:

This issue is that you're using a separate transaction for each step, instead of reusing it, hence why it's running poorly.

db.transaction IS a transaction, so no BEGIN/COMMIT needed.

Try this:

<!DOCTYPE HTML>
<html>
<head>
<script type="text/javascript">
var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
var msg;
db.transaction(function (tx) {
    for(var i=0;i<1000;i++)
    {
        txquer(tx, i,"test");
    }
});
db.transaction(function (tx) {
  tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
   var len = results.rows.length, i;
   msg = "<p>Found rows: " + len + "</p>";
   document.querySelector('#status').innerHTML +=  msg;  
 }, null);
});
function txquer(tx,i,test)
{ 
    tx.executeSql('INSERT INTO LOGS (id, log) VALUES (?, ?)',[i,test]);    
} 
</script>
</head>
<body>
<div id="status" name="status">Status Message</div>
</body>
</html>

Will 2010-10-18 04:46:22

ansaurus

tags:

views:

answers:

How to speed up the process when inserting 1000's of records into sqlite using HTML5

related questions