Best practices for using SQLite3 + Node.js Best practices for using SQLite3 + Node.js sqlite sqlite

Best practices for using SQLite3 + Node.js


When you are doing several insertions into a SQLite database, you need to wrap the collection of insertions into a transaction. Otherwise, SQLite will wait for the disk platters to spin completely around for each insert, while it does a read-after-write verify for each record that you insert.

At 7200 RPM, it takes about 1/60th of a second for the disk platter to spin around again, which is an eternity in computer time.