Skip to main content
Module

x/sqlite3/bench/bench_deno.js

The fastest and correct module for SQLite3 in Deno.
Go to Latest
File
import { Database } from "../mod.ts";
const db = new Database(":memory:", { unsafeConcurrency: true });
db.run("PRAGMA auto_vacuum = none");db.run("PRAGMA temp_store = memory");db.run("PRAGMA locking_mode = exclusive");db.run("PRAGMA user_version = 100");
const sql = "pragma user_version";
let total = parseInt(Deno.args[0], 10);const runs = parseInt(Deno.args[1], 10);
function bench(query) { const start = performance.now(); for (let i = 0; i < runs; i++) query(); const elapsed = Math.floor(performance.now() - start); const rate = Math.floor(runs / (elapsed / 1000)); console.log(`time ${elapsed} ms rate ${rate}`); if (--total) bench(query);}
const query = db.prepare(sql);console.log(query.get());bench(() => query.get());