diff options
| author | eunhhu <[email protected]> | 2026-10-08 16:53:29 +0100 |
|---|---|---|
| committer | eunhhu <[email protected]> | 2026-10-08 16:53:29 +0100 |
| commit | be51c8a15d4f220ea8322f3c562f1f0c51b1e8e7 (patch) | |
| tree | ec49b9aeb46f9ff1b00542d8ea774ef152919865 /research | |
| parent | e7760db551322810de7824f25a38e9f8f737b0ce (diff) | |
| download | pure-be51c8a15d4f220ea8322f3c562f1f0c51b1e8e7.tar.gz pure-be51c8a15d4f220ea8322f3c562f1f0c51b1e8e7.zip | |
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)
Diffstat (limited to 'research')
28 files changed, 202 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}} diff --git a/research/experiments/041-batches/2026-10-08-counts.jsonl b/research/experiments/041-batches/2026-10-08-counts.jsonl index d259259..6770a54 100644 --- a/research/experiments/041-batches/2026-10-08-counts.jsonl +++ b/research/experiments/041-batches/2026-10-08-counts.jsonl @@ -66,3 +66,13 @@ {"version":"b13","way":"rounds","work":"roots","instructions":2755945389,"cycles":987937588} {"version":"b13","way":"batches","work":"join","instructions":1862428182,"cycles":1070892757} {"version":"b13","way":"rounds","work":"join","instructions":7669661642,"cycles":3261839112} +{"version":"b14","way":"batches","work":"bfs","instructions":3367636863,"cycles":1668001492} +{"version":"b14","way":"rounds","work":"bfs","instructions":4711634132,"cycles":2090008896} +{"version":"b14","way":"batches","work":"knapsack","instructions":372331557,"cycles":117955187} +{"version":"b14","way":"rounds","work":"knapsack","instructions":21688103016,"cycles":7544708847} +{"version":"b14","way":"batches","work":"matmul","instructions":718548121,"cycles":242024080} +{"version":"b14","way":"rounds","work":"matmul","instructions":21436715931,"cycles":6621517691} +{"version":"b14","way":"batches","work":"roots","instructions":156139120,"cycles":109411693} +{"version":"b14","way":"rounds","work":"roots","instructions":2755945510,"cycles":988490613} +{"version":"b14","way":"batches","work":"join","instructions":1868676355,"cycles":1061229557} +{"version":"b14","way":"rounds","work":"join","instructions":7669661592,"cycles":3636019220} diff --git a/research/experiments/041-batches/2026-10-08-pairs.jsonl b/research/experiments/041-batches/2026-10-08-pairs.jsonl index 7d1343f..36dd15a 100644 --- a/research/experiments/041-batches/2026-10-08-pairs.jsonl +++ b/research/experiments/041-batches/2026-10-08-pairs.jsonl @@ -308,3 +308,95 @@ {"version":"b13","way":"batches","turn":5,"work":"join","pure_median_ms":118.155,"c_median_ms":30.847,"ratio":3.830,"agree":true} {"version":"b13","way":"batches","turn":5,"work":"matmul","pure_median_ms":26.718,"c_median_ms":7.599,"ratio":3.516,"agree":true} {"version":"b13","way":"batches","turn":5,"work":"bfs","pure_median_ms":24.025,"c_median_ms":10.005,"ratio":2.401,"agree":true} +{"version":"b13","way":"batches","turn":1,"work":"roots","pure_median_ms":8.316,"c_median_ms":6.869,"ratio":1.211,"agree":true} +{"version":"b13","way":"batches","turn":1,"work":"knapsack","pure_median_ms":10.680,"c_median_ms":6.296,"ratio":1.696,"agree":true} +{"version":"b13","way":"batches","turn":1,"work":"join","pure_median_ms":114.792,"c_median_ms":29.910,"ratio":3.838,"agree":true} +{"version":"b13","way":"batches","turn":1,"work":"matmul","pure_median_ms":26.754,"c_median_ms":7.542,"ratio":3.547,"agree":true} +{"version":"b13","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.127,"c_median_ms":10.223,"ratio":2.360,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"roots","pure_median_ms":8.282,"c_median_ms":6.865,"ratio":1.206,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"knapsack","pure_median_ms":10.048,"c_median_ms":6.224,"ratio":1.614,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"join","pure_median_ms":115.119,"c_median_ms":30.225,"ratio":3.809,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.998,"c_median_ms":7.535,"ratio":3.450,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.029,"c_median_ms":9.958,"ratio":2.413,"agree":true} +{"version":"b13","way":"batches","turn":2,"work":"roots","pure_median_ms":8.355,"c_median_ms":6.879,"ratio":1.215,"agree":true} +{"version":"b13","way":"batches","turn":2,"work":"knapsack","pure_median_ms":10.627,"c_median_ms":6.281,"ratio":1.692,"agree":true} +{"version":"b13","way":"batches","turn":2,"work":"join","pure_median_ms":114.690,"c_median_ms":32.100,"ratio":3.573,"agree":true} +{"version":"b13","way":"batches","turn":2,"work":"matmul","pure_median_ms":26.708,"c_median_ms":7.540,"ratio":3.542,"agree":true} +{"version":"b13","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.920,"c_median_ms":10.065,"ratio":2.377,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"roots","pure_median_ms":8.285,"c_median_ms":6.865,"ratio":1.207,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"knapsack","pure_median_ms":10.050,"c_median_ms":6.224,"ratio":1.615,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"join","pure_median_ms":115.790,"c_median_ms":31.902,"ratio":3.630,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.976,"c_median_ms":7.538,"ratio":3.446,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.984,"c_median_ms":9.983,"ratio":2.403,"agree":true} +{"version":"b13","way":"batches","turn":3,"work":"roots","pure_median_ms":8.309,"c_median_ms":6.865,"ratio":1.210,"agree":true} +{"version":"b13","way":"batches","turn":3,"work":"knapsack","pure_median_ms":10.540,"c_median_ms":6.227,"ratio":1.693,"agree":true} +{"version":"b13","way":"batches","turn":3,"work":"join","pure_median_ms":115.973,"c_median_ms":31.762,"ratio":3.651,"agree":true} +{"version":"b13","way":"batches","turn":3,"work":"matmul","pure_median_ms":26.773,"c_median_ms":7.518,"ratio":3.561,"agree":true} +{"version":"b13","way":"batches","turn":3,"work":"bfs","pure_median_ms":24.051,"c_median_ms":10.067,"ratio":2.389,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"roots","pure_median_ms":8.280,"c_median_ms":6.866,"ratio":1.206,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"knapsack","pure_median_ms":10.034,"c_median_ms":6.229,"ratio":1.611,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"join","pure_median_ms":117.243,"c_median_ms":31.426,"ratio":3.731,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.945,"c_median_ms":7.523,"ratio":3.449,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"bfs","pure_median_ms":24.154,"c_median_ms":10.190,"ratio":2.370,"agree":true} +{"version":"b13","way":"batches","turn":4,"work":"roots","pure_median_ms":8.312,"c_median_ms":6.861,"ratio":1.211,"agree":true} +{"version":"b13","way":"batches","turn":4,"work":"knapsack","pure_median_ms":10.576,"c_median_ms":6.226,"ratio":1.699,"agree":true} +{"version":"b13","way":"batches","turn":4,"work":"join","pure_median_ms":116.402,"c_median_ms":29.137,"ratio":3.995,"agree":true} +{"version":"b13","way":"batches","turn":4,"work":"matmul","pure_median_ms":26.717,"c_median_ms":7.663,"ratio":3.487,"agree":true} +{"version":"b13","way":"batches","turn":4,"work":"bfs","pure_median_ms":24.260,"c_median_ms":10.011,"ratio":2.423,"agree":true} +{"version":"b14","way":"batches","turn":4,"work":"roots","pure_median_ms":8.287,"c_median_ms":6.863,"ratio":1.207,"agree":true} +{"version":"b14","way":"batches","turn":4,"work":"knapsack","pure_median_ms":10.163,"c_median_ms":6.448,"ratio":1.576,"agree":true} +{"version":"b14","way":"batches","turn":4,"work":"join","pure_median_ms":115.463,"c_median_ms":30.471,"ratio":3.789,"agree":true} +{"version":"b14","way":"batches","turn":4,"work":"matmul","pure_median_ms":25.997,"c_median_ms":7.540,"ratio":3.448,"agree":true} +{"version":"b14","way":"batches","turn":4,"work":"bfs","pure_median_ms":24.003,"c_median_ms":10.093,"ratio":2.378,"agree":true} +{"version":"b13","way":"batches","turn":5,"work":"roots","pure_median_ms":8.308,"c_median_ms":6.861,"ratio":1.211,"agree":true} +{"version":"b13","way":"batches","turn":5,"work":"knapsack","pure_median_ms":10.533,"c_median_ms":6.267,"ratio":1.681,"agree":true} +{"version":"b13","way":"batches","turn":5,"work":"join","pure_median_ms":115.249,"c_median_ms":31.876,"ratio":3.616,"agree":true} +{"version":"b13","way":"batches","turn":5,"work":"matmul","pure_median_ms":26.792,"c_median_ms":7.545,"ratio":3.551,"agree":true} +{"version":"b13","way":"batches","turn":5,"work":"bfs","pure_median_ms":24.135,"c_median_ms":10.019,"ratio":2.409,"agree":true} +{"version":"b14","way":"batches","turn":5,"work":"roots","pure_median_ms":8.300,"c_median_ms":6.873,"ratio":1.207,"agree":true} +{"version":"b14","way":"batches","turn":5,"work":"knapsack","pure_median_ms":10.102,"c_median_ms":6.227,"ratio":1.622,"agree":true} +{"version":"b14","way":"batches","turn":5,"work":"join","pure_median_ms":117.360,"c_median_ms":31.328,"ratio":3.746,"agree":true} +{"version":"b14","way":"batches","turn":5,"work":"matmul","pure_median_ms":25.966,"c_median_ms":7.539,"ratio":3.444,"agree":true} +{"version":"b14","way":"batches","turn":5,"work":"bfs","pure_median_ms":24.080,"c_median_ms":10.060,"ratio":2.394,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"roots","pure_median_ms":8.962,"c_median_ms":6.872,"ratio":1.304,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"knapsack","pure_median_ms":11.500,"c_median_ms":6.240,"ratio":1.843,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"sort","pure_median_ms":56.898,"c_median_ms":26.876,"ratio":2.117,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"join","pure_median_ms":119.329,"c_median_ms":31.836,"ratio":3.748,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"words","pure_median_ms":216.527,"c_median_ms":38.123,"ratio":5.680,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"matmul","pure_median_ms":40.022,"c_median_ms":7.521,"ratio":5.322,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.087,"c_median_ms":9.953,"ratio":2.420,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"roots","pure_median_ms":8.286,"c_median_ms":6.863,"ratio":1.207,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"knapsack","pure_median_ms":10.067,"c_median_ms":6.231,"ratio":1.616,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"sort","pure_median_ms":56.739,"c_median_ms":26.883,"ratio":2.111,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"join","pure_median_ms":115.954,"c_median_ms":31.075,"ratio":3.731,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"words","pure_median_ms":217.494,"c_median_ms":38.742,"ratio":5.614,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.983,"c_median_ms":7.546,"ratio":3.443,"agree":true} +{"version":"b14","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.120,"c_median_ms":10.133,"ratio":2.380,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"roots","pure_median_ms":8.965,"c_median_ms":6.869,"ratio":1.305,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"knapsack","pure_median_ms":11.418,"c_median_ms":6.231,"ratio":1.832,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"sort","pure_median_ms":56.910,"c_median_ms":26.892,"ratio":2.116,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"join","pure_median_ms":116.789,"c_median_ms":30.559,"ratio":3.822,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"words","pure_median_ms":214.333,"c_median_ms":39.039,"ratio":5.490,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"matmul","pure_median_ms":40.032,"c_median_ms":7.601,"ratio":5.266,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"bfs","pure_median_ms":24.051,"c_median_ms":10.104,"ratio":2.380,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"roots","pure_median_ms":8.286,"c_median_ms":6.867,"ratio":1.207,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"knapsack","pure_median_ms":10.107,"c_median_ms":6.230,"ratio":1.622,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"sort","pure_median_ms":56.756,"c_median_ms":26.876,"ratio":2.112,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"join","pure_median_ms":115.280,"c_median_ms":30.595,"ratio":3.768,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"words","pure_median_ms":220.892,"c_median_ms":38.701,"ratio":5.708,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.951,"c_median_ms":7.535,"ratio":3.444,"agree":true} +{"version":"b14","way":"batches","turn":2,"work":"bfs","pure_median_ms":24.336,"c_median_ms":9.945,"ratio":2.447,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"roots","pure_median_ms":8.963,"c_median_ms":6.863,"ratio":1.306,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"knapsack","pure_median_ms":11.456,"c_median_ms":6.247,"ratio":1.834,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"sort","pure_median_ms":57.041,"c_median_ms":26.902,"ratio":2.120,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"join","pure_median_ms":117.863,"c_median_ms":31.866,"ratio":3.699,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"words","pure_median_ms":213.690,"c_median_ms":39.481,"ratio":5.412,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"matmul","pure_median_ms":39.951,"c_median_ms":7.982,"ratio":5.005,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"bfs","pure_median_ms":24.316,"c_median_ms":10.086,"ratio":2.411,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"roots","pure_median_ms":8.287,"c_median_ms":6.863,"ratio":1.208,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"knapsack","pure_median_ms":10.071,"c_median_ms":6.228,"ratio":1.617,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"sort","pure_median_ms":56.973,"c_median_ms":26.895,"ratio":2.118,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"join","pure_median_ms":115.795,"c_median_ms":32.216,"ratio":3.594,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"words","pure_median_ms":219.174,"c_median_ms":38.390,"ratio":5.709,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.934,"c_median_ms":7.564,"ratio":3.428,"agree":true} +{"version":"b14","way":"batches","turn":3,"work":"bfs","pure_median_ms":27.887,"c_median_ms":10.578,"ratio":2.636,"agree":true} |
