aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authoreunhhu <[email protected]>2026-09-30 18:38:18 +0100
committereunhhu <[email protected]>2026-09-30 18:38:18 +0100
commit2168466cc9302ce95a5f3381f6c663ca4c180a28 (patch)
tree3d8f6b8504b1558b5d9b963f95ca59335ed377ca
parentd5b3fe85d7da3131b315410e316d8abe95dab61e (diff)
downloadpure-2168466cc9302ce95a5f3381f6c663ca4c180a28.tar.gz
pure-2168466cc9302ce95a5f3381f6c663ca4c180a28.zip
Measure 07047c3 again on a quiet Pi (110)
The six pairs rerun once the Pi had been quiet for a minute, on the same binaries. Two pairs were still interfered (the first's before at an owner share of 0.54, the sixth at 0.73 on both sides); the four clean ones are -1.7%, -0.4%, +1.8% and +1.1%, CPU per transaction 43.25 to 42.9 us. The bank's queries are as fast or faster after, though the interference fell more on the before runs; the instruction counts stay the comparison to trust.
-rw-r--r--docs/research/110-counting-instead-of-timing.md23
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-load.txt12
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-1-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-2-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-3-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-4-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-5-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-6-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-1-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-2-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-3-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-4-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-5-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-6-linux-aarch64.jsonl4
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-1-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-2-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-3-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-4-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-5-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-6-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-1-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-2-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-3-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-4-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-5-linux-aarch64.jsonl3
-rw-r--r--research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-6-linux-aarch64.jsonl3
26 files changed, 116 insertions, 3 deletions
diff --git a/docs/research/110-counting-instead-of-timing.md b/docs/research/110-counting-instead-of-timing.md
index c84a06c..86fa5f5 100644
--- a/docs/research/110-counting-instead-of-timing.md
+++ b/docs/research/110-counting-instead-of-timing.md
@@ -86,12 +86,29 @@
`cell_at`이 따로 불리는 함수로 나타난다(0% → 2.98%). 전에는 `pure_list_get` 안에 인라인되어 있었다. 기계어로 보면 칸의 종류를
묻는 검사가 `cbz` 하나에서 네 명령이 되며 커졌다. 고친 뒤(`fcc1f67`)에는 다시 0%다.
-**고친 뒤의 여섯 쌍**(`fcc1f67-interfered`). 둘째 라운드부터 다른 세션의 빌드가 부하 평균을 4–12로 올렸다. 소유자의 코어 몫이
-0.55–0.89로 떨어졌고, 쌍마다 −29%에서 +80%까지 흔들린다. 판정에 쓰지 않는다. 지우지 않고 남긴다.
+**고친 뒤의 여섯 쌍.** 처음 잰 것(`fcc1f67-interfered`)은 둘째 라운드부터 다른 세션의 빌드가 부하 평균을 4–12로 올렸다. 소유자의
+코어 몫이 0.55–0.89로 떨어졌고, 쌍마다 −29%에서 +80%까지 흔들린다. 판정에 쓰지 않는다. 지우지 않고 남긴다.
+
+Pi가 1분 넘게 조용해졌을 때 같은 바이너리로 다시 쟀다(`fcc1f67`, 부하 평균은 0.3에서 시작해 1.4–3.9로 올랐다).
+
+| 쌍 | 초당 거래(전 → 후) | 거래당 CPU(µs) | 소유자의 코어 몫 |
+|---|---:|---:|---:|
+| 1 | 17,749 → 43,659 | 62.1 → 42.9 | 0.54 → 0.90 (전이 방해받음) |
+| 2 | 44,346 → 43,576 (−1.7%) | 43.0 → 43.6 | 0.90 → 0.90 |
+| 3 | 44,382 → 44,206 (−0.4%) | 43.1 → 42.6 | 0.91 → 0.91 |
+| 4 | 43,832 → 44,604 (+1.8%) | 43.4 → 42.7 | 0.90 → 0.91 |
+| 5 | 43,447 → 43,905 (+1.1%) | 43.7 → 43.1 | 0.90 → 0.90 |
+| 6 | 31,885 → 32,117 (+0.7%) | 47.7 → 47.1 | 0.73 → 0.73 (둘 다 방해받음) |
+
+여섯 쌍의 중앙값은 43,640 → 43,782(+0.3%)다. 깨끗한 네 쌍(2–5)의 거래당 CPU는 43.25 → 42.9 µs(−0.8%)다. 은행 질의의
+중앙값은 모두 후가 같거나 빠르다(`ranks` 6.84 → 6.80, `per_branch` 5.37 → 5.21, `large` 0.40 → 0.39, `in_credit` 1.00 →
+0.85). 다만 방해가 전의 실행에 더 걸렸다(첫 라운드의 전, `in_credit`의 전 셋). 그래서 빠른 쪽으로 기운 숫자다. 이 비교에서는
+명령 수가 더 믿을 만하다.
## 판정
-- **016의 2단계는 들어간다.** 기준을 채웠다(`fc65d66`의 여섯 쌍). 고친 뒤(`fcc1f67`)는 수의 경로에서 그보다 명령이 적다.
+- **016의 2단계는 들어간다.** 기준을 채웠다(`fc65d66`의 여섯 쌍). 고친 뒤(`fcc1f67`)는 수의 경로에서 그보다 명령이 적고,
+ 시간으로도 전과 가려지지 않는다(깨끗한 네 쌍 −1.7%에서 +1.8%).
- **남은 것**은 명령 +0.4%에서 +1.4%다. 여러 함수에 한두 명령씩 흩어져 있다. 칸의 종류 검사(`text` 표시 한 바이트에서 종류
번호의 비교로), 커진 `run`의 새 경우들이다. 사이클로는 전과 가려지지 않는다.
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-load.txt b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-load.txt
new file mode 100644
index 0000000..148bf2d
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-load.txt
@@ -0,0 +1,12 @@
+1 before 18:18:47 up 1 day, 21:31, 3 users, load average: 0.25, 1.13, 3.09
+1 after 18:20:42 up 1 day, 21:33, 3 users, load average: 3.43, 2.39, 3.34
+2 after 18:22:08 up 1 day, 21:34, 3 users, load average: 2.04, 2.23, 3.20
+2 before 18:23:35 up 1 day, 21:36, 3 users, load average: 1.83, 2.20, 3.10
+3 before 18:25:03 up 1 day, 21:37, 3 users, load average: 2.02, 2.29, 3.06
+3 after 18:26:30 up 1 day, 21:38, 3 users, load average: 1.43, 2.05, 2.90
+4 after 18:27:56 up 1 day, 21:40, 3 users, load average: 1.70, 2.05, 2.83
+4 before 18:29:23 up 1 day, 21:41, 3 users, load average: 2.16, 2.19, 2.81
+5 before 18:30:51 up 1 day, 21:43, 3 users, load average: 1.82, 2.13, 2.74
+5 after 18:32:19 up 1 day, 21:44, 3 users, load average: 3.87, 2.58, 2.83
+6 after 18:34:15 up 1 day, 21:46, 3 users, load average: 3.31, 2.76, 2.87
+6 before 18:36:06 up 1 day, 21:48, 3 users, load average: 2.63, 2.86, 2.91
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..db86621
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-1-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.18, "pure_fastest_ms": 5.11, "sqlite_median_ms": 45.48, "sqlite_fastest_ms": 45.28, "sqlite_indexed_median_ms": 14.03, "sqlite_indexed_fastest_ms": 13.95}
+{"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.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.76, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2838.58, "sqlite_fastest_ms": 2837.63, "sqlite_indexed_median_ms": 7.54, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..14dc702
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-2-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.2, "pure_fastest_ms": 5.11, "sqlite_median_ms": 45.31, "sqlite_fastest_ms": 45.09, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "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.39, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.82, "pure_fastest_ms": 6.69, "sqlite_median_ms": 2835.58, "sqlite_fastest_ms": 2834.02, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.49}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..e449dc9
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-3-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.2, "pure_fastest_ms": 5.14, "sqlite_median_ms": 44.96, "sqlite_fastest_ms": 44.82, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 14.05}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "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.38, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.47, "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.74, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2836.97, "sqlite_fastest_ms": 2832.3, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.48}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..46110f8
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-4-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 6.44, "pure_fastest_ms": 5.07, "sqlite_median_ms": 45.02, "sqlite_fastest_ms": 44.83, "sqlite_indexed_median_ms": 14.08, "sqlite_indexed_fastest_ms": 14.05}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "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.4, "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.8, "pure_fastest_ms": 6.67, "sqlite_median_ms": 2839.58, "sqlite_fastest_ms": 2834.53, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.49}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-5-linux-aarch64.jsonl
new file mode 100644
index 0000000..38bb12e
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-5-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.23, "pure_fastest_ms": 5.12, "sqlite_median_ms": 45.36, "sqlite_fastest_ms": 45.21, "sqlite_indexed_median_ms": 14.33, "sqlite_indexed_fastest_ms": 14.2}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "pure_fastest_ms": 0.76, "sqlite_median_ms": 6.21, "sqlite_fastest_ms": 5.98, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.73, "pure_fastest_ms": 0.57, "sqlite_median_ms": 1.52, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.67, "sqlite_indexed_fastest_ms": 1.63}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.91, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2858.23, "sqlite_fastest_ms": 2838.75, "sqlite_indexed_median_ms": 7.96, "sqlite_indexed_fastest_ms": 7.88}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-6-linux-aarch64.jsonl
new file mode 100644
index 0000000..f73fe24
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-after-6-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.14, "sqlite_median_ms": 45.0, "sqlite_fastest_ms": 44.82, "sqlite_indexed_median_ms": 14.19, "sqlite_indexed_fastest_ms": 14.16}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.93, "pure_fastest_ms": 0.79, "sqlite_median_ms": 5.92, "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.36, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.49, "sqlite_indexed_median_ms": 1.55, "sqlite_indexed_fastest_ms": 1.5}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.8, "pure_fastest_ms": 6.73, "sqlite_median_ms": 2853.46, "sqlite_fastest_ms": 2835.85, "sqlite_indexed_median_ms": 7.67, "sqlite_indexed_fastest_ms": 7.61}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..928f6a6
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-1-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 7.49, "pure_fastest_ms": 6.91, "sqlite_median_ms": 54.62, "sqlite_fastest_ms": 52.41, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.01}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.79, "pure_fastest_ms": 1.43, "sqlite_median_ms": 6.31, "sqlite_fastest_ms": 6.23, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.99, "pure_fastest_ms": 0.82, "sqlite_median_ms": 1.88, "sqlite_fastest_ms": 1.79, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 11.39, "pure_fastest_ms": 8.86, "sqlite_median_ms": 2851.98, "sqlite_fastest_ms": 2834.15, "sqlite_indexed_median_ms": 7.64, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..2d40f25
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-2-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 6.24, "pure_fastest_ms": 6.15, "sqlite_median_ms": 45.15, "sqlite_fastest_ms": 44.96, "sqlite_indexed_median_ms": 14.16, "sqlite_indexed_fastest_ms": 14.01}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.9, "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.37, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.46, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.8, "pure_fastest_ms": 6.7, "sqlite_median_ms": 2834.29, "sqlite_fastest_ms": 2827.75, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.52}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..7be8143
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-3-linux-aarch64.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.26, "sqlite_fastest_ms": 45.16, "sqlite_indexed_median_ms": 14.16, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "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.37, "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.74, "pure_fastest_ms": 6.61, "sqlite_median_ms": 2837.96, "sqlite_fastest_ms": 2831.55, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.51}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..91705a4
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-4-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.29, "pure_fastest_ms": 5.12, "sqlite_median_ms": 45.37, "sqlite_fastest_ms": 45.23, "sqlite_indexed_median_ms": 14.19, "sqlite_indexed_fastest_ms": 14.01}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.06, "pure_fastest_ms": 0.81, "sqlite_median_ms": 6.06, "sqlite_fastest_ms": 5.94, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16}
+{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.51, "pure_fastest_ms": 0.45, "sqlite_median_ms": 1.62, "sqlite_fastest_ms": 1.53, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.5}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.87, "pure_fastest_ms": 6.76, "sqlite_median_ms": 2836.68, "sqlite_fastest_ms": 2832.47, "sqlite_indexed_median_ms": 7.67, "sqlite_indexed_fastest_ms": 7.59}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-5-linux-aarch64.jsonl
new file mode 100644
index 0000000..0967d09
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-5-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.24, "pure_fastest_ms": 5.19, "sqlite_median_ms": 45.55, "sqlite_fastest_ms": 44.88, "sqlite_indexed_median_ms": 14.42, "sqlite_indexed_fastest_ms": 14.3}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.08, "pure_fastest_ms": 0.99, "sqlite_median_ms": 6.01, "sqlite_fastest_ms": 5.91, "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.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.67, "sqlite_indexed_fastest_ms": 1.63}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.66, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2890.88, "sqlite_fastest_ms": 2839.02, "sqlite_indexed_median_ms": 7.91, "sqlite_indexed_fastest_ms": 7.89}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-6-linux-aarch64.jsonl
new file mode 100644
index 0000000..e23e526
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-queries-before-6-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.45, "pure_fastest_ms": 5.37, "sqlite_median_ms": 45.21, "sqlite_fastest_ms": 44.94, "sqlite_indexed_median_ms": 14.21, "sqlite_indexed_fastest_ms": 14.14}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.94, "pure_fastest_ms": 0.89, "sqlite_median_ms": 5.96, "sqlite_fastest_ms": 5.91, "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.39, "sqlite_median_ms": 1.5, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.94, "pure_fastest_ms": 6.86, "sqlite_median_ms": 2847.66, "sqlite_fastest_ms": 2836.55, "sqlite_indexed_median_ms": 7.58, "sqlite_indexed_fastest_ms": 7.48}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..0e73a89
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-1-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.74, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43659, "new_orders_per_minute": 1168121, "undone_new_orders": 3738, "errors": 0, "new_order": {"done": 393114, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 375299, "failed": 0, "p50_us": 1408, "p99_us": 3456}, "order_status": {"done": 35020, "failed": 0, "p50_us": 256, "p99_us": 1344}, "delivery": {"done": 34948, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "stock_level": {"done": 34799, "failed": 0, "p50_us": 288, "p99_us": 1536}, "server_threads": "3", "cpu_us_per_transaction": 42.9, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 458.3, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 458.3, "pure_state_mib": 232.6, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26900, "burst_events": 799689, "checkpoints": 39}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..6fbf8ad
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-2-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.74, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43576, "new_orders_per_minute": 1166011, "undone_new_orders": 3730, "errors": 0, "new_order": {"done": 392406, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "payment": {"done": 374552, "failed": 0, "p50_us": 1408, "p99_us": 3584}, "order_status": {"done": 34945, "failed": 0, "p50_us": 256, "p99_us": 1344}, "delivery": {"done": 34913, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "stock_level": {"done": 34721, "failed": 0, "p50_us": 288, "p99_us": 1536}, "server_threads": "3", "cpu_us_per_transaction": 43.6, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 457.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 457.2, "pure_state_mib": 232.2, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26868, "burst_events": 798224, "checkpoints": 39}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..1c9a9cd
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-3-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.74, "sqlite_load_s": 1.63, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44206, "new_orders_per_minute": 1182531, "undone_new_orders": 3804, "errors": 0, "new_order": {"done": 397988, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "payment": {"done": 380008, "failed": 0, "p50_us": 1408, "p99_us": 3200}, "order_status": {"done": 35504, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 35390, "failed": 0, "p50_us": 1408, "p99_us": 3200}, "stock_level": {"done": 35253, "failed": 0, "p50_us": 288, "p99_us": 1344}, "server_threads": "3", "cpu_us_per_transaction": 42.6, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 462.8, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 462.8, "pure_state_mib": 235.1, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27085, "burst_events": 809667, "checkpoints": 40}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..65805d4
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-4-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.74, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44604, "new_orders_per_minute": 1193263, "undone_new_orders": 3825, "errors": 0, "new_order": {"done": 401580, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 383396, "failed": 0, "p50_us": 1408, "p99_us": 2944}, "order_status": {"done": 35793, "failed": 0, "p50_us": 248, "p99_us": 1152}, "delivery": {"done": 35735, "failed": 0, "p50_us": 1408, "p99_us": 3072}, "stock_level": {"done": 35576, "failed": 0, "p50_us": 272, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 42.7, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 465.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 465.5, "pure_state_mib": 237.1, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27101, "burst_events": 816961, "checkpoints": 40}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-5-linux-aarch64.jsonl
new file mode 100644
index 0000000..8a9194e
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-5-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.6, "pure_load_s": 0.82, "sqlite_load_s": 1.64, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43905, "new_orders_per_minute": 1174828, "undone_new_orders": 3759, "errors": 0, "new_order": {"done": 395373, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 377377, "failed": 0, "p50_us": 1408, "p99_us": 3456}, "order_status": {"done": 35207, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 35143, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "stock_level": {"done": 35005, "failed": 0, "p50_us": 288, "p99_us": 1344}, "server_threads": "3", "cpu_us_per_transaction": 43.1, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 460.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 460.1, "pure_state_mib": 233.8, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26613, "burst_events": 804217, "checkpoints": 39}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-6-linux-aarch64.jsonl
new file mode 100644
index 0000000..88ed30b
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-after-6-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.59, "pure_load_s": 0.88, "sqlite_load_s": 1.73, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 32117, "new_orders_per_minute": 857984, "undone_new_orders": 2725, "errors": 0, "new_order": {"done": 288722, "failed": 0, "p50_us": 1984, "p99_us": 4608}, "payment": {"done": 276554, "failed": 0, "p50_us": 1984, "p99_us": 4352}, "order_status": {"done": 25873, "failed": 0, "p50_us": 336, "p99_us": 2176}, "delivery": {"done": 25720, "failed": 0, "p50_us": 1984, "p99_us": 4608}, "stock_level": {"done": 25481, "failed": 0, "p50_us": 384, "p99_us": 2176}, "server_threads": "3", "cpu_us_per_transaction": 47.1, "core_shares": {"pure-owner": 0.73, "pure-checkpoint": 0.01}, "resident_mib": 355.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 355.2, "pure_state_mib": 176.7, "pure_store_mib": 182.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 19240, "burst_events": 588356, "checkpoints": 28}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..8e033a8
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-1-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.81, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 17749, "new_orders_per_minute": 473961, "undone_new_orders": 1499, "errors": 0, "new_order": {"done": 159492, "failed": 0, "p50_us": 3328, "p99_us": 10240}, "payment": {"done": 152826, "failed": 0, "p50_us": 3328, "p99_us": 10240}, "order_status": {"done": 14356, "failed": 0, "p50_us": 480, "p99_us": 5120}, "delivery": {"done": 14200, "failed": 0, "p50_us": 3328, "p99_us": 10240}, "stock_level": {"done": 14128, "failed": 0, "p50_us": 576, "p99_us": 5120}, "server_threads": "3", "cpu_us_per_transaction": 62.1, "core_shares": {"pure-owner": 0.54, "pure-checkpoint": 0.0}, "resident_mib": 214.4, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 214.4, "pure_state_mib": 107.6, "pure_store_mib": 110.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 9893, "burst_events": 325059, "checkpoints": 15}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..b8477a8
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-2-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.61, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44346, "new_orders_per_minute": 1186502, "undone_new_orders": 3805, "errors": 0, "new_order": {"done": 399307, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 381210, "failed": 0, "p50_us": 1408, "p99_us": 3072}, "order_status": {"done": 35575, "failed": 0, "p50_us": 256, "p99_us": 1152}, "delivery": {"done": 35480, "failed": 0, "p50_us": 1408, "p99_us": 3072}, "stock_level": {"done": 35359, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 43.0, "core_shares": {"pure-owner": 0.9, "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": 235.9, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26831, "burst_events": 812269, "checkpoints": 40}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..ba039e6
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-3-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44382, "new_orders_per_minute": 1187337, "undone_new_orders": 3811, "errors": 0, "new_order": {"done": 399594, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "payment": {"done": 381516, "failed": 0, "p50_us": 1408, "p99_us": 2944}, "order_status": {"done": 35569, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35545, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "stock_level": {"done": 35418, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 43.1, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 465.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 465.0, "pure_state_mib": 236.0, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26886, "burst_events": 812928, "checkpoints": 40}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..ca027b3
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-4-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.72, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43832, "new_orders_per_minute": 1172894, "undone_new_orders": 3758, "errors": 0, "new_order": {"done": 394723, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "payment": {"done": 376722, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "order_status": {"done": 35172, "failed": 0, "p50_us": 256, "p99_us": 1152}, "delivery": {"done": 35101, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "stock_level": {"done": 34926, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 43.4, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 458.3, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 458.3, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26552, "burst_events": 802872, "checkpoints": 39}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-5-linux-aarch64.jsonl
new file mode 100644
index 0000000..1aa40c8
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-5-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.73, "sqlite_load_s": 1.71, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43447, "new_orders_per_minute": 1162420, "undone_new_orders": 3713, "errors": 0, "new_order": {"done": 391190, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "payment": {"done": 373502, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "order_status": {"done": 34830, "failed": 0, "p50_us": 256, "p99_us": 1280}, "delivery": {"done": 34768, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "stock_level": {"done": 34650, "failed": 0, "p50_us": 288, "p99_us": 1344}, "server_threads": "3", "cpu_us_per_transaction": 43.7, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 454.8, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 454.8, "pure_state_mib": 231.5, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26634, "burst_events": 795833, "checkpoints": 39}}
diff --git a/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-6-linux-aarch64.jsonl
new file mode 100644
index 0000000..ada2e79
--- /dev/null
+++ b/research/experiments/025-i64-cost/fcc1f67/2026-09-30-tpcc-before-6-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.74, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 31885, "new_orders_per_minute": 852039, "undone_new_orders": 2709, "errors": 0, "new_order": {"done": 286722, "failed": 0, "p50_us": 1984, "p99_us": 4864}, "payment": {"done": 274507, "failed": 0, "p50_us": 1984, "p99_us": 4608}, "order_status": {"done": 25661, "failed": 0, "p50_us": 336, "p99_us": 2176}, "delivery": {"done": 25536, "failed": 0, "p50_us": 1984, "p99_us": 4608}, "stock_level": {"done": 25282, "failed": 0, "p50_us": 384, "p99_us": 2432}, "server_threads": "3", "cpu_us_per_transaction": 47.7, "core_shares": {"pure-owner": 0.73, "pure-checkpoint": 0.01}, "resident_mib": 352.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 352.2, "pure_state_mib": 175.7, "pure_store_mib": 182.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 19720, "burst_events": 584140, "checkpoints": 28}}