Better-sqlite3 performance issues with Electron

Question

This is more a question than a proper issue.

I have implemented the better-sqilite3 npm in an electron app. I have an Android app that uses the Cordova sqlite plugin and I am testing the time running the queries and realize that the better-sqlite3 is 10x slower than the Cordova sqlite plugin.

Is this normal or is something in the code that I need to increase performance?

The app is the same that runs on Android and Electron and the commands are the same.

Miguel Coelho · Accepted Answer · 2025-01-27 22:41:28Z

0

The way that I solved my problem was by changing the journal_mode to 'WAL' instead of using the default one because I was using many batch inserts.

More details in this GitHub issue: https://github.com/WiseLibs/better-sqlite3/issues/1323#issuecomment-2616665140

answered Jan 27 at 22:41

Miguel Coelho

911 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Better-sqlite3 performance issues with Electron

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related