Research 136: the batch executor's stage 3 (four-byte MUL, reductions with no lanes while every lane's e is the same, a list's cells once a batch): against b9, interleaved, matmul 40.01 to 25.97 ms, knapsack 11.47 to 10.07, roots 8.97 to 8.29, join 117.2 to 115.8, BFS and sort the same; sum0 8.69 to 1.01 (bar 1.5); matmul short of its bar (21): the nested rounds' interpretation (about 14 ms) and the matrices' making (4-5) were left out of the arithmetic; the executor alone and the bank queries' instructions as b9 (0.08%), TPC-C +0.7%; stage 4 next (knapsack's six passes to three)

26 files changed, 100 insertions, 0 deletions

diff --git a/research/experiments/040-against-c/2026-10-08-counts.jsonl b/research/experiments/040-against-c/2026-10-08-counts.jsonl
new file mode 100644
index 0000000..9ded043
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-counts.jsonl
@@ -0,0 +1,4 @@
+{"serve": "pure-serve", "per_branch": {"instructions": 27084449, "cycles": 11968165}, "in_credit": {"instructions": 3511883, "cycles": 1642481}, "large": {"instructions": 1419139, "cycles": 694322}, "ranks": {"instructions": 24469168, "cycles": 14816231}, "none": {"instructions": 615600, "cycles": 198839}, "field": {"instructions": 9007132, "cycles": 3270346}, "found": {"instructions": 14139059, "cycles": 10647982}}
+{"serve": "pure-serve", "per_branch": {"instructions": 26979581, "cycles": 12079370}, "in_credit": {"instructions": 3488341, "cycles": 1623673}, "large": {"instructions": 1419195, "cycles": 618093}, "ranks": {"instructions": 24411710, "cycles": 15102017}, "none": {"instructions": 615600, "cycles": 199844}, "field": {"instructions": 9007132, "cycles": 3258526}, "found": {"instructions": 14138874, "cycles": 10788782}}
+{"serve": "pure-serve", "per_branch": {"instructions": 27066442, "cycles": 11989768}, "in_credit": {"instructions": 3507837, "cycles": 1610192}, "large": {"instructions": 1419139, "cycles": 616080}, "ranks": {"instructions": 24460594, "cycles": 14902801}, "none": {"instructions": 615600, "cycles": 193159}, "field": {"instructions": 9007132, "cycles": 3277228}, "found": {"instructions": 14140402, "cycles": 10893077}}
+{"serve": "pure-serve", "per_branch": {"instructions": 27195249, "cycles": 12143448}, "in_credit": {"instructions": 3536801, "cycles": 1672046}, "large": {"instructions": 1419139, "cycles": 612837}, "ranks": {"instructions": 24530686, "cycles": 15174100}, "none": {"instructions": 615600, "cycles": 194135}, "field": {"instructions": 9007235, "cycles": 3279139}, "found": {"instructions": 14137235, "cycles": 10915766}}
diff --git a/research/experiments/040-against-c/2026-10-08-load.txt b/research/experiments/040-against-c/2026-10-08-load.txt
new file mode 100644
index 0000000..e17ec65
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-load.txt
@@ -0,0 +1,12 @@
+1 s9  16:22:57 up 4 days, 12:44,  2 users,  load average: 1.32, 1.34, 1.11
+1 s14  16:24:25 up 4 days, 12:45,  2 users,  load average: 1.47, 1.44, 1.17
+2 s14  16:26:01 up 4 days, 12:47,  2 users,  load average: 1.35, 1.49, 1.22
+2 s9  16:27:49 up 4 days, 12:49,  2 users,  load average: 1.46, 1.55, 1.27
+3 s9  16:29:16 up 4 days, 12:50,  2 users,  load average: 1.48, 1.60, 1.32
+3 s14  16:30:53 up 4 days, 12:52,  2 users,  load average: 1.37, 1.63, 1.36
+4 s14  16:32:30 up 4 days, 12:53,  2 users,  load average: 1.31, 1.60, 1.38
+4 s9  16:34:07 up 4 days, 12:55,  2 users,  load average: 1.32, 1.60, 1.41
+5 s9  16:35:34 up 4 days, 12:56,  2 users,  load average: 1.34, 1.58, 1.42
+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
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s14-1.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s14-1.jsonl
new file mode 100644
index 0000000..8ab0066
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s14-1.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.32, "pure_fastest_ms": 5.25, "sqlite_median_ms": 44.93, "sqlite_fastest_ms": 44.85, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.05}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.8, "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.38, "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.77, "pure_fastest_ms": 6.7, "sqlite_median_ms": 2842.0, "sqlite_fastest_ms": 2838.67, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s14-2.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s14-2.jsonl
new file mode 100644
index 0000000..28b485a
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s14-2.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.31, "pure_fastest_ms": 5.2, "sqlite_median_ms": 45.25, "sqlite_fastest_ms": 45.09, "sqlite_indexed_median_ms": 14.0, "sqlite_indexed_fastest_ms": 13.96}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "pure_fastest_ms": 0.82, "sqlite_median_ms": 5.89, "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.37, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.89, "pure_fastest_ms": 6.79, "sqlite_median_ms": 2841.84, "sqlite_fastest_ms": 2838.85, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s14-3.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s14-3.jsonl
new file mode 100644
index 0000000..37c986b
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s14-3.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.25, "pure_fastest_ms": 5.18, "sqlite_median_ms": 45.25, "sqlite_fastest_ms": 45.17, "sqlite_indexed_median_ms": 14.02, "sqlite_indexed_fastest_ms": 13.96}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "pure_fastest_ms": 0.81, "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.38, "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.85, "pure_fastest_ms": 6.75, "sqlite_median_ms": 2845.71, "sqlite_fastest_ms": 2840.64, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s14-4.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s14-4.jsonl
new file mode 100644
index 0000000..1b0f465
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s14-4.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.35, "pure_fastest_ms": 5.22, "sqlite_median_ms": 45.23, "sqlite_fastest_ms": 45.13, "sqlite_indexed_median_ms": 14.1, "sqlite_indexed_fastest_ms": 14.03}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.89, "pure_fastest_ms": 0.82, "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.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.83, "pure_fastest_ms": 6.78, "sqlite_median_ms": 2843.8, "sqlite_fastest_ms": 2840.72, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s14-5.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s14-5.jsonl
new file mode 100644
index 0000000..5a42b6c
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s14-5.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.23, "sqlite_fastest_ms": 45.16, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.05}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.82, "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.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": 6.82, "pure_fastest_ms": 6.71, "sqlite_median_ms": 2842.74, "sqlite_fastest_ms": 2840.54, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s14-6.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s14-6.jsonl
new file mode 100644
index 0000000..34ee9bf
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s14-6.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.27, "pure_fastest_ms": 5.23, "sqlite_median_ms": 45.48, "sqlite_fastest_ms": 45.29, "sqlite_indexed_median_ms": 14.07, "sqlite_indexed_fastest_ms": 14.06}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.91, "pure_fastest_ms": 0.83, "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.49, "pure_fastest_ms": 0.41, "sqlite_median_ms": 1.53, "sqlite_fastest_ms": 1.48, "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.68, "sqlite_median_ms": 2841.65, "sqlite_fastest_ms": 2838.36, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-1.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-1.jsonl
new file mode 100644
index 0000000..1892a39
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-1.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.13, "sqlite_median_ms": 45.97, "sqlite_fastest_ms": 44.91, "sqlite_indexed_median_ms": 14.07, "sqlite_indexed_fastest_ms": 14.01}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "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.37, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.5, "sqlite_fastest_ms": 1.49, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.72, "pure_fastest_ms": 6.65, "sqlite_median_ms": 2841.05, "sqlite_fastest_ms": 2837.7, "sqlite_indexed_median_ms": 7.66, "sqlite_indexed_fastest_ms": 7.56}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-2.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-2.jsonl
new file mode 100644
index 0000000..9861f6f
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-2.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.47, "sqlite_fastest_ms": 45.23, "sqlite_indexed_median_ms": 14.09, "sqlite_indexed_fastest_ms": 14.04}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.8, "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.38, "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.46}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.66, "pure_fastest_ms": 6.6, "sqlite_median_ms": 2841.94, "sqlite_fastest_ms": 2837.62, "sqlite_indexed_median_ms": 7.58, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-3.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-3.jsonl
new file mode 100644
index 0000000..e938103
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-3.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.23, "pure_fastest_ms": 5.17, "sqlite_median_ms": 45.27, "sqlite_fastest_ms": 45.13, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.04}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.81, "pure_fastest_ms": 0.78, "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.47, "pure_fastest_ms": 0.45, "sqlite_median_ms": 1.98, "sqlite_fastest_ms": 1.96, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.81, "pure_fastest_ms": 6.67, "sqlite_median_ms": 2842.97, "sqlite_fastest_ms": 2839.88, "sqlite_indexed_median_ms": 7.71, "sqlite_indexed_fastest_ms": 7.58}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-4.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-4.jsonl
new file mode 100644
index 0000000..8fbac45
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-4.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.37, "pure_fastest_ms": 5.2, "sqlite_median_ms": 45.03, "sqlite_fastest_ms": 44.9, "sqlite_indexed_median_ms": 14.2, "sqlite_indexed_fastest_ms": 14.02}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "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.36, "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.8, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2841.51, "sqlite_fastest_ms": 2839.17, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-5.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-5.jsonl
new file mode 100644
index 0000000..367b66e
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-5.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.91, "pure_fastest_ms": 5.67, "sqlite_median_ms": 45.1, "sqlite_fastest_ms": 44.84, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.94, "sqlite_fastest_ms": 5.89, "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.51, "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": 8.3, "pure_fastest_ms": 6.69, "sqlite_median_ms": 2844.17, "sqlite_fastest_ms": 2840.26, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/040-against-c/2026-10-08-queries-s9-6.jsonl b/research/experiments/040-against-c/2026-10-08-queries-s9-6.jsonl
new file mode 100644
index 0000000..f2326e4
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-queries-s9-6.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 6.36, "pure_fastest_ms": 5.6, "sqlite_median_ms": 45.02, "sqlite_fastest_ms": 44.78, "sqlite_indexed_median_ms": 14.13, "sqlite_indexed_fastest_ms": 14.09}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.8, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.93, "sqlite_fastest_ms": 5.89, "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.47, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.68, "pure_fastest_ms": 6.59, "sqlite_median_ms": 2845.17, "sqlite_fastest_ms": 2840.45, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s14-1.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s14-1.jsonl
new file mode 100644
index 0000000..01245ab
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s14-1.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": 43268, "new_orders_per_minute": 1157814, "undone_new_orders": 3696, "errors": 0, "new_order": {"done": 389639, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "payment": {"done": 371876, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "order_status": {"done": 34715, "failed": 0, "p50_us": 272, "p99_us": 1600}, "delivery": {"done": 34662, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "stock_level": {"done": 34473, "failed": 0, "p50_us": 320, "p99_us": 1728}, "server_threads": "3", "cpu_us_per_transaction": 44.8, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 457.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 457.1, "pure_state_mib": 230.7, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27214, "burst_events": 792567, "checkpoints": 38}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s14-2.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s14-2.jsonl
new file mode 100644
index 0000000..f2544b5
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s14-2.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.6, "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": 43828, "new_orders_per_minute": 1172531, "undone_new_orders": 3755, "errors": 0, "new_order": {"done": 394599, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "payment": {"done": 376774, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "order_status": {"done": 35151, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 35116, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "stock_level": {"done": 34919, "failed": 0, "p50_us": 320, "p99_us": 1664}, "server_threads": "3", "cpu_us_per_transaction": 45.0, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 462.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 462.7, "pure_state_mib": 233.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27852, "burst_events": 802821, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s14-3.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s14-3.jsonl
new file mode 100644
index 0000000..cd30413
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s14-3.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.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": 43857, "new_orders_per_minute": 1173370, "undone_new_orders": 3747, "errors": 0, "new_order": {"done": 394872, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 377021, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35170, "failed": 0, "p50_us": 288, "p99_us": 1472}, "delivery": {"done": 35132, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34941, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 45.0, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 462.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 462.7, "pure_state_mib": 233.5, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27586, "burst_events": 803363, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s14-4.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s14-4.jsonl
new file mode 100644
index 0000000..e99fbc7
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s14-4.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.3, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43727, "new_orders_per_minute": 1169756, "undone_new_orders": 3742, "errors": 0, "new_order": {"done": 393661, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "payment": {"done": 375969, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "order_status": {"done": 35088, "failed": 0, "p50_us": 288, "p99_us": 1536}, "delivery": {"done": 34997, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "stock_level": {"done": 34833, "failed": 0, "p50_us": 336, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 45.1, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 461.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 461.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": 27840, "burst_events": 800970, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s14-5.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s14-5.jsonl
new file mode 100644
index 0000000..34b913d
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s14-5.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.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": 44245, "new_orders_per_minute": 1183964, "undone_new_orders": 3801, "errors": 0, "new_order": {"done": 398470, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "payment": {"done": 380311, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35472, "failed": 0, "p50_us": 272, "p99_us": 1344}, "delivery": {"done": 35417, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "stock_level": {"done": 35270, "failed": 0, "p50_us": 320, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 466.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 466.9, "pure_state_mib": 235.4, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27676, "burst_events": 810479, "checkpoints": 40}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s14-6.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s14-6.jsonl
new file mode 100644
index 0000000..9d8548a
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s14-6.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.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": 43446, "new_orders_per_minute": 1162307, "undone_new_orders": 3724, "errors": 0, "new_order": {"done": 391165, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "payment": {"done": 373501, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "order_status": {"done": 34852, "failed": 0, "p50_us": 272, "p99_us": 1536}, "delivery": {"done": 34779, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "stock_level": {"done": 34640, "failed": 0, "p50_us": 320, "p99_us": 1728}, "server_threads": "3", "cpu_us_per_transaction": 45.1, "core_shares": {"pure-owner": 0.87, "pure-checkpoint": 0.01}, "resident_mib": 459.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 459.0, "pure_state_mib": 231.5, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27240, "burst_events": 795807, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-1.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-1.jsonl
new file mode 100644
index 0000000..1ce46b3
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-1.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": 42571, "new_orders_per_minute": 1138875, "undone_new_orders": 3636, "errors": 0, "new_order": {"done": 383262, "failed": 0, "p50_us": 1472, "p99_us": 4352}, "payment": {"done": 365985, "failed": 0, "p50_us": 1408, "p99_us": 4352}, "order_status": {"done": 34157, "failed": 0, "p50_us": 272, "p99_us": 1664}, "delivery": {"done": 34101, "failed": 0, "p50_us": 1408, "p99_us": 4608}, "stock_level": {"done": 33926, "failed": 0, "p50_us": 320, "p99_us": 1792}, "server_threads": "3", "cpu_us_per_transaction": 45.3, "core_shares": {"pure-owner": 0.87, "pure-checkpoint": 0.01}, "resident_mib": 450.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 450.5, "pure_state_mib": 227.3, "pure_store_mib": 230.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26595, "burst_events": 779797, "checkpoints": 38}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-2.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-2.jsonl
new file mode 100644
index 0000000..d11edfc
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-2.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.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": 43257, "new_orders_per_minute": 1157193, "undone_new_orders": 3698, "errors": 0, "new_order": {"done": 389429, "failed": 0, "p50_us": 1472, "p99_us": 3840}, "payment": {"done": 371903, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 34691, "failed": 0, "p50_us": 288, "p99_us": 1408}, "delivery": {"done": 34628, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34485, "failed": 0, "p50_us": 320, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 45.7, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 456.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 456.9, "pure_state_mib": 230.6, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26938, "burst_events": 792348, "checkpoints": 38}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-3.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-3.jsonl
new file mode 100644
index 0000000..2b18a3d
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-3.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": 43179, "new_orders_per_minute": 1155181, "undone_new_orders": 3684, "errors": 0, "new_order": {"done": 388747, "failed": 0, "p50_us": 1472, "p99_us": 3968}, "payment": {"done": 371169, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 34640, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 34609, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "stock_level": {"done": 34428, "failed": 0, "p50_us": 320, "p99_us": 1728}, "server_threads": "3", "cpu_us_per_transaction": 45.3, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 456.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 456.1, "pure_state_mib": 230.2, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27048, "burst_events": 790926, "checkpoints": 38}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-4.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-4.jsonl
new file mode 100644
index 0000000..b0fc954
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-4.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.67, "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": 43828, "new_orders_per_minute": 1172606, "undone_new_orders": 3756, "errors": 0, "new_order": {"done": 394625, "failed": 0, "p50_us": 1472, "p99_us": 3712}, "payment": {"done": 376799, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35116, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 35099, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34928, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 45.3, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 462.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 462.2, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27677, "burst_events": 802851, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-5.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-5.jsonl
new file mode 100644
index 0000000..f13985c
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-5.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.63, "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": 43662, "new_orders_per_minute": 1168176, "undone_new_orders": 3740, "errors": 0, "new_order": {"done": 393132, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "payment": {"done": 375324, "failed": 0, "p50_us": 1408, "p99_us": 3968}, "order_status": {"done": 34997, "failed": 0, "p50_us": 272, "p99_us": 1536}, "delivery": {"done": 34990, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "stock_level": {"done": 34805, "failed": 0, "p50_us": 320, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 45.1, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 460.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 460.7, "pure_state_mib": 232.5, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27485, "burst_events": 799789, "checkpoints": 39}}
diff --git a/research/experiments/040-against-c/2026-10-08-tpcc-s9-6.jsonl b/research/experiments/040-against-c/2026-10-08-tpcc-s9-6.jsonl
new file mode 100644
index 0000000..10a6273
--- /dev/null
+++ b/research/experiments/040-against-c/2026-10-08-tpcc-s9-6.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.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": 44338, "new_orders_per_minute": 1186242, "undone_new_orders": 3798, "errors": 0, "new_order": {"done": 399212, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "payment": {"done": 381130, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 35554, "failed": 0, "p50_us": 272, "p99_us": 1472}, "delivery": {"done": 35518, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 35355, "failed": 0, "p50_us": 320, "p99_us": 1664}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 467.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 467.2, "pure_state_mib": 235.8, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27935, "burst_events": 812140, "checkpoints": 40}}