aboutsummaryrefslogtreecommitdiff
path: root/bench/sqlite/node.mjs
diff options
context:
space:
mode:
Diffstat (limited to 'bench/sqlite/node.mjs')
-rw-r--r--bench/sqlite/node.mjs31
1 files changed, 31 insertions, 0 deletions
diff --git a/bench/sqlite/node.mjs b/bench/sqlite/node.mjs
new file mode 100644
index 000000000..9bf25105b
--- /dev/null
+++ b/bench/sqlite/node.mjs
@@ -0,0 +1,31 @@
+import { run, bench } from "mitata";
+import { createRequire } from "module";
+
+const require = createRequire(import.meta.url);
+const db = require("better-sqlite3")("./src/northwind.sqlite");
+
+{
+ const sql = db.prepare(`SELECT * FROM "Order"`);
+
+ bench('SELECT * FROM "Order"', () => {
+ sql.all();
+ });
+}
+
+{
+ const sql = db.prepare(`SELECT * FROM "Product"`);
+
+ bench('SELECT * FROM "Product"', () => {
+ sql.all();
+ });
+}
+
+{
+ const sql = db.prepare(`SELECT * FROM "OrderDetail"`);
+
+ bench('SELECT * FROM "OrderDetail"', () => {
+ sql.all();
+ });
+}
+
+await run();