1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
import {  bench,  runBenchmarks,} from "https://deno.land/std@0.135.0/testing/bench.ts";import { DB } from "./mod.ts";
if (Deno.args[0]) {  try {    await Deno.remove(Deno.args[0]);  } catch (_) {    // ignore  }}
const dbFile = Deno.args[0] || ":memory:";const db = new DB(dbFile);
db.query(  "CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, balance INTEGER)",);
/** Performance of insert statements (1 insert). */const names = "Deno Land Peter Parker Clark Kent Robert Parr".split(" ");
bench({  name: "insert 10 000 (named)",  runs: 100,  func: (b): void => {    b.start();    const query = db.prepareQuery(      "INSERT INTO users (name, balance) VALUES (:name, :balance)",    );    db.query("begin");    for (let i = 0; i < 10_000; i++) {      query.execute({ name: names[i % names.length], balance: i });    }    db.query("commit");    b.stop();  },});
bench({  name: "insert 10 000 (positional)",  runs: 100,  func: (b): void => {    b.start();    const query = db.prepareQuery(      "INSERT INTO users (name, balance) VALUES (?, ?)",    );    db.query("begin");    for (let i = 0; i < 10_000; i++) {      query.execute([names[i % names.length], i]);    }    db.query("commit");    b.stop();  },});
/** Performance of select statements (select all; 10_000). */bench({  name: "select 10 000 (select all)",  runs: 100,  func: (b): void => {    b.start();    db.query(      "SELECT name, balance FROM users LIMIT 10000",    );    b.stop();  },});
/** Performance of select statements (select individually; 10_000). */bench({  name: "select 10 000 (select first)",  runs: 100,  func: (b): void => {    b.start();    const query = db.prepareQuery(      "SELECT name, balance FROM users WHERE id = ?",    );    for (let id = 1; id <= 10_000; id++) {      query.first([id]);    }    b.stop();  },});
runBenchmarks();