sqlite3/bench/northwind/deno_old.js at 7bc4f08226b33706d00ead8680f2948913374990 · sigmaSd/sqlite3 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import { Database } from "https://deno.land/x/sqlite3@0.4.3/mod.ts";
import { bench, run } from "../../node_modules/mitata/src/cli.mjs";

const db = new Database("./bench/northwind.sqlite");

{
  const sql = db.prepare(`SELECT * FROM "Order"`);
  bench('SELECT * FROM "Order"', () => {
    sql.reset();
    const rows = [];
    for (const row of sql) {
      rows.push(row.asObject());
    }
  });
}

{
  const sql = db.prepare(`SELECT * FROM "Product"`);
  bench('SELECT * FROM "Product"', () => {
    sql.reset();
    const rows = [];
    for (const row of sql) {
      rows.push(row.asObject());
    }
  });
}

{
  const sql = db.prepare(`SELECT * FROM "OrderDetail"`);
  bench('SELECT * FROM "OrderDetail"', () => {
    sql.reset();
    const rows = [];
    for (const row of sql) {
      rows.push(row.asObject());
    }
  });
}

await run();