Research 137: the batch executor's stage 4 (columns read in place, comparisons counting their lanes): knapsack 10.07 to 8.25 ms (bar 8.6; b9 11.46, the compiled code 7.9), its instructions 12.2% below b9's; what is left of knapsack's gap is the per-batch interpretation (about 3 ms), not the kernels (ADD 1.7, GT 1.7, the masked set 0.55 ms); the others the same by instructions; make check's server_view_workers timed out once (the known flake), passed 3/3 alone and in a full rerun; bank queries' instructions within 0.1% of b9's, TPC-C -0.3%; the two large gaps left (matmul's nested rounds, BFS's candidate tail) the user's to choose

26 files changed, 100 insertions, 0 deletions

diff --git a/research/experiments/040-against-c/2026-10-08-counts-s16.jsonl b/research/experiments/040-against-c/2026-10-08-counts-s16.jsonl
new file mode 100644
index 0000000..03e3b17
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-counts-s16.jsonl
@@ -0,0 +1,4 @@
+{"serve": "pure-serve", "per_branch": {"instructions": 27206437, "cycles": 12193908}, "in_credit": {"instructions": 3539491, "cycles": 1590320}, "large": {"instructions": 1419171, "cycles": 620624}, "ranks": {"instructions": 24538485, "cycles": 14924796}, "none": {"instructions": 615600, "cycles": 194460}, "field": {"instructions": 9007132, "cycles": 3290082}, "found": {"instructions": 14138875, "cycles": 10513744}}
+{"serve": "pure-serve", "per_branch": {"instructions": 27174503, "cycles": 12152935}, "in_credit": {"instructions": 3532203, "cycles": 1643873}, "large": {"instructions": 1419155, "cycles": 615898}, "ranks": {"instructions": 24519864, "cycles": 15205679}, "none": {"instructions": 615600, "cycles": 194254}, "field": {"instructions": 9007132, "cycles": 3275460}, "found": {"instructions": 14139691, "cycles": 10954635}}
+{"serve": "pure-serve", "per_branch": {"instructions": 27142081, "cycles": 12144302}, "in_credit": {"instructions": 3524900, "cycles": 1623796}, "large": {"instructions": 1419123, "cycles": 616959}, "ranks": {"instructions": 24501599, "cycles": 14658870}, "none": {"instructions": 615600, "cycles": 193689}, "field": {"instructions": 9007132, "cycles": 3284131}, "found": {"instructions": 14139267, "cycles": 10851692}}
+{"serve": "pure-serve", "per_branch": {"instructions": 27206145, "cycles": 11999425}, "in_credit": {"instructions": 3539418, "cycles": 1785262}, "large": {"instructions": 1419099, "cycles": 611238}, "ranks": {"instructions": 24538778, "cycles": 15150304}, "none": {"instructions": 615600, "cycles": 194966}, "field": {"instructions": 9007132, "cycles": 3261606}, "found": {"instructions": 14138083, "cycles": 10692158}}
diff --git a/research/experiments/040-against-c/2026-10-08-load.txt b/research/experiments/040-against-c/2026-10-08-load.txt
index e17ec65..7ae2dad 100644
--- a/research/experiments/040-against-c/2026-10-08-load.txt
+++ b/research/experiments/040-against-c/2026-10-08-load.txt
@@ -10,3 +10,15 @@
 5 s14  16:37:01 up 4 days, 12:58,  2 users,  load average: 1.46, 1.64, 1.46
 6 s14  16:38:48 up 4 days, 13:00,  2 users,  load average: 1.33, 1.67, 1.50
 6 s9  16:40:15 up 4 days, 13:01,  2 users,  load average: 1.37, 1.65, 1.51
+7 s9  17:28:17 up 4 days, 13:49,  2 users,  load average: 1.46, 1.33, 1.24
+7 s16  17:30:04 up 4 days, 13:51,  2 users,  load average: 1.41, 1.45, 1.30
+8 s16  17:31:50 up 4 days, 13:53,  2 users,  load average: 1.28, 1.50, 1.34
+8 s9  17:33:17 up 4 days, 13:54,  2 users,  load average: 1.36, 1.53, 1.36
+9 s9  17:34:44 up 4 days, 13:56,  2 users,  load average: 1.38, 1.54, 1.38
+9 s16  17:36:21 up 4 days, 13:57,  2 users,  load average: 1.36, 1.59, 1.42
+10 s16  17:37:58 up 4 days, 13:59,  2 users,  load average: 1.32, 1.61, 1.45
+10 s9  17:39:35 up 4 days, 14:00,  2 users,  load average: 1.43, 1.67, 1.50
+11 s9  17:41:31 up 4 days, 14:02,  2 users,  load average: 1.28, 1.70, 1.54
+11 s16  17:42:58 up 4 days, 14:04,  2 users,  load average: 1.29, 1.64, 1.53
+12 s16  17:44:35 up 4 days, 14:05,  2 users,  load average: 1.31, 1.65, 1.55
+12 s9  17:46:13 up 4 days, 14:07,  2 users,  load average: 1.32, 1.67, 1.57
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s16-10.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s16-10.jsonl
new file mode 100644
index 0000000..3aae710
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s16-10.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.34, "pure_fastest_ms": 5.27, "sqlite_median_ms": 45.06, "sqlite_fastest_ms": 44.83, "sqlite_indexed_median_ms": 14.01, "sqlite_indexed_fastest_ms": 13.92}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.82, "pure_fastest_ms": 6.74, "sqlite_median_ms": 2841.82, "sqlite_fastest_ms": 2838.35, "sqlite_indexed_median_ms": 7.54, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s16-11.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s16-11.jsonl
new file mode 100644
index 0000000..2b215d3
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s16-11.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.28, "pure_fastest_ms": 5.19, "sqlite_median_ms": 45.34, "sqlite_fastest_ms": 45.2, "sqlite_indexed_median_ms": 14.08, "sqlite_indexed_fastest_ms": 14.03}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 7.06, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2843.39, "sqlite_fastest_ms": 2836.98, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s16-12.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s16-12.jsonl
new file mode 100644
index 0000000..4a3ce77
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s16-12.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.28, "pure_fastest_ms": 5.18, "sqlite_median_ms": 45.5, "sqlite_fastest_ms": 45.27, "sqlite_indexed_median_ms": 14.15, "sqlite_indexed_fastest_ms": 14.06}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.19, "pure_fastest_ms": 1.04, "sqlite_median_ms": 6.29, "sqlite_fastest_ms": 6.26, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 1.06, "pure_fastest_ms": 0.7, "sqlite_median_ms": 1.87, "sqlite_fastest_ms": 1.51, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 8.2, "pure_fastest_ms": 6.77, "sqlite_median_ms": 2883.56, "sqlite_fastest_ms": 2837.2, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s16-7.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s16-7.jsonl
new file mode 100644
index 0000000..19e90f5
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s16-7.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.3, "pure_fastest_ms": 5.2, "sqlite_median_ms": 45.29, "sqlite_fastest_ms": 45.12, "sqlite_indexed_median_ms": 14.03, "sqlite_indexed_fastest_ms": 13.98}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.9, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.41, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.48}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.76, "pure_fastest_ms": 6.69, "sqlite_median_ms": 2845.34, "sqlite_fastest_ms": 2837.97, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s16-8.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s16-8.jsonl
new file mode 100644
index 0000000..0d86f4b
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s16-8.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.25, "pure_fastest_ms": 5.19, "sqlite_median_ms": 45.45, "sqlite_fastest_ms": 45.14, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.08}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.79, "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.39, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.75, "pure_fastest_ms": 6.68, "sqlite_median_ms": 2841.25, "sqlite_fastest_ms": 2837.71, "sqlite_indexed_median_ms": 7.63, "sqlite_indexed_fastest_ms": 7.55}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s16-9.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s16-9.jsonl
new file mode 100644
index 0000000..d856aa6
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s16-9.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.24, "pure_fastest_ms": 5.14, "sqlite_median_ms": 44.93, "sqlite_fastest_ms": 44.8, "sqlite_indexed_median_ms": 14.02, "sqlite_indexed_fastest_ms": 13.97}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.4, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.48}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.79, "pure_fastest_ms": 6.68, "sqlite_median_ms": 2843.9, "sqlite_fastest_ms": 2841.47, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-10.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-10.jsonl
new file mode 100644
index 0000000..f540655
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-10.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.16, "sqlite_median_ms": 45.33, "sqlite_fastest_ms": 45.25, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.11}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.79, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.36, "pure_fastest_ms": 0.34, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.69, "pure_fastest_ms": 6.65, "sqlite_median_ms": 2842.19, "sqlite_fastest_ms": 2838.4, "sqlite_indexed_median_ms": 7.58, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-11.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-11.jsonl
new file mode 100644
index 0000000..ec6e5d6
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-11.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.23, "pure_fastest_ms": 5.16, "sqlite_median_ms": 45.27, "sqlite_fastest_ms": 45.09, "sqlite_indexed_median_ms": 14.07, "sqlite_indexed_fastest_ms": 14.05}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.8, "pure_fastest_ms": 0.77, "sqlite_median_ms": 5.91, "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.37, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.67, "pure_fastest_ms": 6.61, "sqlite_median_ms": 2841.8, "sqlite_fastest_ms": 2836.15, "sqlite_indexed_median_ms": 7.66, "sqlite_indexed_fastest_ms": 7.54}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-12.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-12.jsonl
new file mode 100644
index 0000000..be9690b
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-12.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.16, "sqlite_median_ms": 45.32, "sqlite_fastest_ms": 45.07, "sqlite_indexed_median_ms": 14.12, "sqlite_indexed_fastest_ms": 14.04}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.79, "sqlite_median_ms": 5.89, "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.41, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.72, "pure_fastest_ms": 6.64, "sqlite_median_ms": 2843.24, "sqlite_fastest_ms": 2836.92, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-7.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-7.jsonl
new file mode 100644
index 0000000..c85c42f
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-7.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.19, "pure_fastest_ms": 5.14, "sqlite_median_ms": 45.4, "sqlite_fastest_ms": 45.24, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 14.04}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.37, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.65, "pure_fastest_ms": 6.56, "sqlite_median_ms": 2845.91, "sqlite_fastest_ms": 2839.83, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-8.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-8.jsonl
new file mode 100644
index 0000000..28edd99
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-8.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.3, "pure_fastest_ms": 5.18, "sqlite_median_ms": 45.15, "sqlite_fastest_ms": 44.88, "sqlite_indexed_median_ms": 14.03, "sqlite_indexed_fastest_ms": 14.02}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.92, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.71, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2843.61, "sqlite_fastest_ms": 2837.04, "sqlite_indexed_median_ms": 7.53, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-9.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-9.jsonl
new file mode 100644
index 0000000..9d1cc08
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-9.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.5, "pure_fastest_ms": 5.21, "sqlite_median_ms": 44.93, "sqlite_fastest_ms": 44.8, "sqlite_indexed_median_ms": 14.02, "sqlite_indexed_fastest_ms": 13.97}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "pure_fastest_ms": 0.79, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.77, "pure_fastest_ms": 6.72, "sqlite_median_ms": 2840.89, "sqlite_fastest_ms": 2838.34, "sqlite_indexed_median_ms": 7.58, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s16-10.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s16-10.jsonl
new file mode 100644
index 0000000..37d622d
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s16-10.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43700, "new_orders_per_minute": 1169271, "undone_new_orders": 3735, "errors": 0, "new_order": {"done": 393493, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 375662, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 35030, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 34984, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "stock_level": {"done": 34839, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 460.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 460.9, "pure_state_mib": 232.8, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27177, "burst_events": 800477, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s16-11.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s16-11.jsonl
new file mode 100644
index 0000000..e0b2227
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s16-11.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.55, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43732, "new_orders_per_minute": 1170025, "undone_new_orders": 3743, "errors": 0, "new_order": {"done": 393752, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 375942, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 35080, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 35007, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "stock_level": {"done": 34863, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 461.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 461.1, "pure_state_mib": 232.9, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27530, "burst_events": 801043, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s16-12.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s16-12.jsonl
new file mode 100644
index 0000000..1d7e195
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s16-12.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43736, "new_orders_per_minute": 1170461, "undone_new_orders": 3752, "errors": 0, "new_order": {"done": 393908, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "payment": {"done": 375877, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "order_status": {"done": 35067, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 35018, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "stock_level": {"done": 34849, "failed": 0, "p50_us": 320, "p99_us": 1536}, "server_threads": "3", "cpu_us_per_transaction": 44.8, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 461.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 461.6, "pure_state_mib": 233.0, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27228, "burst_events": 801126, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s16-7.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s16-7.jsonl
new file mode 100644
index 0000000..9d75263
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s16-7.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.64, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43466, "new_orders_per_minute": 1163095, "undone_new_orders": 3715, "errors": 0, "new_order": {"done": 391414, "failed": 0, "p50_us": 1472, "p99_us": 3968}, "payment": {"done": 373599, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 34869, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 34796, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "stock_level": {"done": 34638, "failed": 0, "p50_us": 320, "p99_us": 1664}, "server_threads": "3", "cpu_us_per_transaction": 44.8, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 459.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 459.2, "pure_state_mib": 231.6, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27164, "burst_events": 796179, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s16-8.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s16-8.jsonl
new file mode 100644
index 0000000..b2ca2c6
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s16-8.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.66, "sqlite_load_s": 1.55, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43823, "new_orders_per_minute": 1172345, "undone_new_orders": 3758, "errors": 0, "new_order": {"done": 394541, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 376720, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35137, "failed": 0, "p50_us": 272, "p99_us": 1600}, "delivery": {"done": 35126, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34936, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 44.9, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 462.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 462.6, "pure_state_mib": 233.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27411, "burst_events": 802712, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s16-9.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s16-9.jsonl
new file mode 100644
index 0000000..766563b
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s16-9.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.59, "pure_load_s": 0.65, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44555, "new_orders_per_minute": 1192195, "undone_new_orders": 3824, "errors": 0, "new_order": {"done": 401224, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 382951, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35736, "failed": 0, "p50_us": 272, "p99_us": 1344}, "delivery": {"done": 35669, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 35529, "failed": 0, "p50_us": 320, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 44.4, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 469.4, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 469.4, "pure_state_mib": 236.9, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28140, "burst_events": 816097, "checkpoints": 40}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-10.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-10.jsonl
new file mode 100644
index 0000000..ba6ab90
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-10.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.55, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43443, "new_orders_per_minute": 1162169, "undone_new_orders": 3717, "errors": 0, "new_order": {"done": 391107, "failed": 0, "p50_us": 1472, "p99_us": 3840}, "payment": {"done": 373496, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 34847, "failed": 0, "p50_us": 288, "p99_us": 1536}, "delivery": {"done": 34798, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34615, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 45.5, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 458.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 458.6, "pure_state_mib": 231.5, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27421, "burst_events": 795770, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-11.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-11.jsonl
new file mode 100644
index 0000000..9e917d2
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-11.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.65, "sqlite_load_s": 1.55, "sqlite_page_size": 4096, "pure_resident_mib": 40.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43819, "new_orders_per_minute": 1172497, "undone_new_orders": 3754, "errors": 0, "new_order": {"done": 394588, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 376631, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 35152, "failed": 0, "p50_us": 272, "p99_us": 1408}, "delivery": {"done": 35082, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34930, "failed": 0, "p50_us": 320, "p99_us": 1536}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 462.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 462.5, "pure_state_mib": 233.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27300, "burst_events": 802632, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-12.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-12.jsonl
new file mode 100644
index 0000000..7bc222d
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-12.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.6, "pure_load_s": 0.65, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44013, "new_orders_per_minute": 1177574, "undone_new_orders": 3780, "errors": 0, "new_order": {"done": 396316, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "payment": {"done": 378342, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35284, "failed": 0, "p50_us": 272, "p99_us": 1408}, "delivery": {"done": 35244, "failed": 0, "p50_us": 1408, "p99_us": 3584}, "stock_level": {"done": 35109, "failed": 0, "p50_us": 320, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 44.9, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 464.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 464.0, "pure_state_mib": 234.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27563, "burst_events": 806205, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-7.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-7.jsonl
new file mode 100644
index 0000000..9c38301
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-7.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 40.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44544, "new_orders_per_minute": 1191783, "undone_new_orders": 3813, "errors": 0, "new_order": {"done": 401074, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "payment": {"done": 382915, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35707, "failed": 0, "p50_us": 272, "p99_us": 1344}, "delivery": {"done": 35669, "failed": 0, "p50_us": 1408, "p99_us": 3584}, "stock_level": {"done": 35516, "failed": 0, "p50_us": 304, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 44.1, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 468.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 468.7, "pure_state_mib": 236.8, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27816, "burst_events": 815931, "checkpoints": 40}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-8.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-8.jsonl
new file mode 100644
index 0000000..64cbe9f
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-8.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43468, "new_orders_per_minute": 1163020, "undone_new_orders": 3717, "errors": 0, "new_order": {"done": 391391, "failed": 0, "p50_us": 1408, "p99_us": 4352}, "payment": {"done": 373661, "failed": 0, "p50_us": 1408, "p99_us": 4352}, "order_status": {"done": 34873, "failed": 0, "p50_us": 272, "p99_us": 1536}, "delivery": {"done": 34817, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "stock_level": {"done": 34621, "failed": 0, "p50_us": 320, "p99_us": 1664}, "server_threads": "3", "cpu_us_per_transaction": 44.3, "core_shares": {"pure-owner": 0.87, "pure-checkpoint": 0.01}, "resident_mib": 459.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 459.5, "pure_state_mib": 231.6, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27330, "burst_events": 796229, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-9.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-9.jsonl
new file mode 100644
index 0000000..a968081
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-9.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.65, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43922, "new_orders_per_minute": 1175457, "undone_new_orders": 3775, "errors": 0, "new_order": {"done": 395594, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 377473, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 35196, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 35162, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "stock_level": {"done": 35015, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 45.0, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 463.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 463.2, "pure_state_mib": 233.9, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27446, "burst_events": 804538, "checkpoints": 39}}