A demonstration of slow sqlite3 bulk inserts in node.js

bulkinsert.js

// Demonstration that bulk insertsin Node.js sqlite3 using prepared statements is very slow.
// Usage: run with one command line argument, one of "db", "reuse", "finalize"
// Details: http://nelsonslog.wordpress.com/2014/11/16/node-js-sqlite3-very-slow-bulk-inserts/

var sqlite3 = require('sqlite3').verbose();

var start = Date.now();
var db = new sqlite3.Database('inserttest.sqlite');
var mode = process.argv[2], runs = "100";
db.serialize(function() {
    db.run("begin transaction");
    db.run("drop table if exists data");
    db.run("create table data (value integer)");
    var stmt = db.prepare("insert into data values (?)");
    // Three different methods of doing a bulk insert
    for (var i = 0; i < runs; i++) {
        if (mode == "db") {
            db.run("insert into data values (?)", i);
        } else if (mode == "reuse") {
            stmt.run(i);
        } else if (mode == "finalize") {
            stmt = db.prepare("insert into data values (?)");
            stmt.run(i);
            stmt.finalize();
        } else {
            console.log('Command line args must be one of "db", "reuse", "finalize"');
            process.exit(1);
        }
    }
    db.run("commit");
});
db.close(function() {
    // sqlite3 has now fully committed the changes
    console.log((Date.now() - start) + "ms");
});

Revision 2 is no longer slow, I had a bug with the prepared statement vs. the transaction. Details at http://nelsonslog.wordpress.com/2014/11/16/node-js-sqlite3-very-slow-bulk-inserts/

I'd add one more option:
else if ( mode == 'bulk') {

const max = 999; 
const range = Math.min(max, runs-i);
i += Math.min(max-1, runs-i-1);
const values = Array(range).fill().map( (_,i) => i);
const placeholders = values.map(() => "(?)").join(",");
let sql = 'INSERT INTO data VALUES ' + placeholders;
db.run(sql, values);

}