My Win JS SQLite 3 application takes too much time to do inserts

Question

Here I am making app of Sqlite3 database in Windows store apps in HTML /java script.

Right now I am using Sqlite3-WinRT component.

Its working fine but I am not getting required performance. Its taking too much time for insertion data. Is there any way to make the insert performance faster with this library?

If this is not possible, can any one can suggest me any other library or component for using sqlite3 in Windows store apps??

Thanks in advance..

you can use sqlite-net which LinqTOSQL so you can get better performance there — techloverr, Dec 13 '13 at 13:02
I have used SQLite3-WinRT Component I am asking for performance enhancement.So need other Wrapper. — ArchFever, Dec 13 '13 at 13:16
is that compulsory to use SQLite? you can go for indexeddb for HTML5/JS — techloverr, Dec 13 '13 at 13:30
Till now i have developed my app in SQLite...so it would be better if I get any help for Sqlite.... — ArchFever, Dec 13 '13 at 13:35
I don't know the equivalent js calls, but did you try wrapping your inserts in a transaction? Related: [Add lots of data to SQLite Database in C#](http://stackoverflow.com/questions/15671600/add-lots-of-data-to-sqlite-database-in-c-sharp) — chue x, Dec 13 '13 at 15:53
@chue x:thanx for your kind help but can you try to give me transaction in js?? — ArchFever, Dec 14 '13 at 06:42

score 1 · Answer 1 · answered Jul 29 '14 at 13:56

You can try to wrap your insertions in a

"BEGIN TRANSACTION"

and end it with

"COMMIT TRANSACTION"

, this will certainly improve your insertion (I used same wrapper).

If this doesn't work, you can try to use this component, even if it is in C#, you can use it in WinJS.

There is an article on how to improve your insertions and selection using this compoenent.

score -1 · Answer 2 · edited May 23 '17 at 12:07

Transactions have increased performance in C# SQLite3 applications, so they may help you in your Win JS application.

If you look at issue 56 in the SQLite3-WinRT issues list, they show how to use transactions:

SQLite3JS.openAsync(dbPath)
.then(function (db) {
  return db.runAsync('PRAGMA temp_store = MEMORY;');
}).then(function (db) {
  return db.runAsync("BEGIN TRANSACTION;");
});

Some notes:

Issue 56 says that the use of the PRAGMA is temporary, and may not be needed in the future. You should test and see if it is needed.
The code above just starts the transaction. Obviously, you will still need to add: 1) your inserts, and 2) a call to commit or abort the transaction, for example, db.runAsync("COMMIT TRANSACTION;");

My Win JS SQLite 3 application takes too much time to do inserts

2 Answers2