1 files changed, 31 insertions, 0 deletions
diff --git a/bench/sqlite/query.better-sqlite3.mjs b/bench/sqlite/query.better-sqlite3.mjs
new file mode 100644
index 000000000..60e1b962b
--- /dev/null
+++ b/bench/sqlite/query.better-sqlite3.mjs
@@ -0,0 +1,31 @@
+import { bench, run } from "mitata";
+import { createRequire } from "module";
+const db = createRequire(import.meta.url)("better-sqlite3")(
+  "/tmp/northwind.sqlite"
+);
+
+{
+  const sql = db.prepare(`SELECT * FROM "Order"`);
+
+  bench('SELECT * FROM "Order" (objects)', () => {
+    sql.all();
+  });
+}
+
+{
+  const sql = db.prepare(`SELECT * FROM "Product"`);
+
+  bench('SELECT * FROM "Product" (objects)', () => {
+    sql.all();
+  });
+}
+
+{
+  const sql = db.prepare(`SELECT * FROM "OrderDetail"`);
+
+  bench('SELECT * FROM "OrderDetail" (objects)', () => {
+    sql.all();
+  });
+}
+
+run({ json: false });