From e5d9b792497ccbc71ccd777497d40c7a8f8c23bf Mon Sep 17 00:00:00 2001 From: eunhhu Date: Mon, 28 Sep 2026 04:06:22 +0100 Subject: Record queries on the bank beside SQLite (091) 091 measures four queries on pgbench's tables of 100,000 accounts, the same rows and answers on Pure (registered queries, HTTP and JSON included) and SQLite 3.46.1, through each step: items field by field in leaves, folds and filters a leaf at a time, and one pass answering a fold in a column for every row. Per-branch totals went from 398 ms to 4.9 ms (SQLite 45, 14.3 with a DBA's indexes), a three-table join from 3.3 to 0.48 ms (1.47), and each rich account's rank from 9.2 s to 6.8 ms (2.84 s, 7.6 ms with an index); counting accounts in credit takes 1.05 ms where an index lets SQLite count 0.16 ms. Pure declares no index. --- .../017-queries/2026-09-28-bank-queries-linux-aarch64.jsonl | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 research/experiments/017-queries/2026-09-28-bank-queries-linux-aarch64.jsonl (limited to 'research/experiments') diff --git a/research/experiments/017-queries/2026-09-28-bank-queries-linux-aarch64.jsonl b/research/experiments/017-queries/2026-09-28-bank-queries-linux-aarch64.jsonl new file mode 100644 index 0000000..4446efc --- /dev/null +++ b/research/experiments/017-queries/2026-09-28-bank-queries-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 4.91, "pure_fastest_ms": 4.84, "sqlite_median_ms": 45.03, "sqlite_fastest_ms": 44.83, "sqlite_indexed_median_ms": 14.27, "sqlite_indexed_fastest_ms": 14.1} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.05, "pure_fastest_ms": 0.93, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.48, "pure_fastest_ms": 0.45, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.51, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.79, "pure_fastest_ms": 6.76, "sqlite_median_ms": 2839.51, "sqlite_fastest_ms": 2837.71, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.5} -- cgit v1.2.3