aboutsummaryrefslogtreecommitdiff
path: root/bench/sqlite/query.js
diff options
context:
space:
mode:
Diffstat (limited to 'bench/sqlite/query.js')
-rw-r--r--bench/sqlite/query.js26
1 files changed, 26 insertions, 0 deletions
diff --git a/bench/sqlite/query.js b/bench/sqlite/query.js
new file mode 100644
index 000000000..e91a20b0a
--- /dev/null
+++ b/bench/sqlite/query.js
@@ -0,0 +1,26 @@
+import { bench, run } from "mitata";
+import { Database } from "sqlite";
+const db = Database.open("/tmp/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();
+ });
+}
+
+run({ json: false });