diff options
Diffstat (limited to 'research/experiments')
30 files changed, 402 insertions, 0 deletions
diff --git a/research/experiments/040-against-c/2026-10-09-counts-s19.jsonl b/research/experiments/040-against-c/2026-10-09-counts-s19.jsonl new file mode 100644 index 0000000..bd9fb8e --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-counts-s19.jsonl @@ -0,0 +1,4 @@ +{"serve": "pure-serve", "per_branch": {"instructions": 27028260, "cycles": 12034307}, "in_credit": {"instructions": 3499415, "cycles": 1655915}, "large": {"instructions": 1419219, "cycles": 624053}, "ranks": {"instructions": 24439860, "cycles": 14804928}, "none": {"instructions": 615600, "cycles": 191743}, "field": {"instructions": 9007132, "cycles": 3298090}, "found": {"instructions": 14140131, "cycles": 10482262}} +{"serve": "pure-serve", "per_branch": {"instructions": 27424133, "cycles": 12137944}, "in_credit": {"instructions": 3593701, "cycles": 1676054}, "large": {"instructions": 1431730, "cycles": 616384}, "ranks": {"instructions": 24700058, "cycles": 15057545}, "none": {"instructions": 623103, "cycles": 193783}, "field": {"instructions": 9014635, "cycles": 3247081}, "found": {"instructions": 14266286, "cycles": 11003523}} +{"serve": "pure-serve", "per_branch": {"instructions": 27122224, "cycles": 12038968}, "in_credit": {"instructions": 3520445, "cycles": 1763107}, "large": {"instructions": 1419131, "cycles": 642816}, "ranks": {"instructions": 24491522, "cycles": 14633695}, "none": {"instructions": 615600, "cycles": 193641}, "field": {"instructions": 9007132, "cycles": 3277552}, "found": {"instructions": 14140026, "cycles": 10819097}} +{"serve": "pure-serve", "per_branch": {"instructions": 27310837, "cycles": 11973352}, "in_credit": {"instructions": 3568159, "cycles": 1661220}, "large": {"instructions": 1431802, "cycles": 600077}, "ranks": {"instructions": 24636476, "cycles": 14975477}, "none": {"instructions": 623103, "cycles": 194730}, "field": {"instructions": 9014738, "cycles": 3281677}, "found": {"instructions": 14268414, "cycles": 10823038}} diff --git a/research/experiments/040-against-c/2026-10-09-counts-s20.jsonl b/research/experiments/040-against-c/2026-10-09-counts-s20.jsonl new file mode 100644 index 0000000..f85993b --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-counts-s20.jsonl @@ -0,0 +1,4 @@ +{"serve": "pure-serve", "per_branch": {"instructions": 27190859, "cycles": 11923628}, "in_credit": {"instructions": 3535971, "cycles": 1621370}, "large": {"instructions": 1419075, "cycles": 1246561}, "ranks": {"instructions": 24529209, "cycles": 16370948}, "none": {"instructions": 615600, "cycles": 191761}, "field": {"instructions": 9007132, "cycles": 3273249}, "found": {"instructions": 14136507, "cycles": 10671807}} +{"serve": "pure-serve", "per_branch": {"instructions": 27031077, "cycles": 11782678}, "in_credit": {"instructions": 3500145, "cycles": 1580355}, "large": {"instructions": 1419147, "cycles": 612261}, "ranks": {"instructions": 24442044, "cycles": 14890489}, "none": {"instructions": 615600, "cycles": 192773}, "field": {"instructions": 9007235, "cycles": 3271664}, "found": {"instructions": 14138547, "cycles": 10580891}} +{"serve": "pure-serve", "per_branch": {"instructions": 27276075, "cycles": 12075868}, "in_credit": {"instructions": 3555034, "cycles": 1620511}, "large": {"instructions": 1419131, "cycles": 612866}, "ranks": {"instructions": 24576003, "cycles": 14886106}, "none": {"instructions": 615608, "cycles": 195681}, "field": {"instructions": 9007140, "cycles": 3299747}, "found": {"instructions": 14138907, "cycles": 10953537}} +{"serve": "pure-serve", "per_branch": {"instructions": 27153659, "cycles": 11946880}, "in_credit": {"instructions": 3527635, "cycles": 1632103}, "large": {"instructions": 1419075, "cycles": 620533}, "ranks": {"instructions": 24509685, "cycles": 14902018}, "none": {"instructions": 615600, "cycles": 194552}, "field": {"instructions": 9007235, "cycles": 3263885}, "found": {"instructions": 14138019, "cycles": 10716180}} diff --git a/research/experiments/040-against-c/2026-10-09-load.txt b/research/experiments/040-against-c/2026-10-09-load.txt new file mode 100644 index 0000000..7994ced --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-load.txt @@ -0,0 +1,12 @@ +13 s9 15:20:04 up 5 days, 11:41, 2 users, load average: 1.02, 1.27, 1.03 +13 s20 15:21:31 up 5 days, 11:42, 2 users, load average: 1.48, 1.44, 1.12 +14 s20 15:23:18 up 5 days, 11:44, 2 users, load average: 1.34, 1.55, 1.20 +14 s9 15:24:55 up 5 days, 11:46, 2 users, load average: 1.33, 1.60, 1.26 +15 s9 15:26:49 up 5 days, 11:48, 2 users, load average: 1.28, 1.56, 1.29 +15 s20 15:28:43 up 5 days, 11:50, 2 users, load average: 1.33, 1.67, 1.37 +16 s20 15:30:21 up 5 days, 11:51, 2 users, load average: 1.44, 1.74, 1.43 +16 s9 15:31:58 up 5 days, 11:53, 2 users, load average: 1.35, 1.71, 1.45 +17 s9 15:33:24 up 5 days, 11:54, 2 users, load average: 1.39, 1.69, 1.47 +17 s20 15:34:51 up 5 days, 11:56, 2 users, load average: 1.40, 1.66, 1.48 +18 s20 15:36:26 up 5 days, 11:57, 2 users, load average: 1.42, 1.65, 1.50 +18 s9 15:38:33 up 5 days, 11:59, 2 users, load average: 1.49, 1.68, 1.53 diff --git a/research/experiments/040-against-c/2026-10-09-queries-s20-13.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s20-13.jsonl new file mode 100644 index 0000000..2483a20 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s20-13.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 7.07, "pure_fastest_ms": 7.04, "sqlite_median_ms": 45.26, "sqlite_fastest_ms": 45.12, "sqlite_indexed_median_ms": 14.12, "sqlite_indexed_fastest_ms": 14.05} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.79, "sqlite_median_ms": 5.9, "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.36, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.71, "pure_fastest_ms": 6.58, "sqlite_median_ms": 2842.21, "sqlite_fastest_ms": 2837.58, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.51} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s20-14.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s20-14.jsonl new file mode 100644 index 0000000..616807b --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s20-14.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.18, "pure_fastest_ms": 5.15, "sqlite_median_ms": 44.98, "sqlite_fastest_ms": 44.88, "sqlite_indexed_median_ms": 14.05, "sqlite_indexed_fastest_ms": 13.98} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.37, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.68, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2839.68, "sqlite_fastest_ms": 2837.51, "sqlite_indexed_median_ms": 7.88, "sqlite_indexed_fastest_ms": 7.67} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s20-15.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s20-15.jsonl new file mode 100644 index 0000000..1929b69 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s20-15.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.28, "sqlite_fastest_ms": 45.13, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 13.98} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "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.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.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.66, "pure_fastest_ms": 6.58, "sqlite_median_ms": 2839.66, "sqlite_fastest_ms": 2837.7, "sqlite_indexed_median_ms": 7.58, "sqlite_indexed_fastest_ms": 7.51} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s20-16.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s20-16.jsonl new file mode 100644 index 0000000..d05d4ff --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s20-16.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.29, "pure_fastest_ms": 5.19, "sqlite_median_ms": 44.97, "sqlite_fastest_ms": 44.82, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.04} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.81, "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.4, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.53, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.71, "pure_fastest_ms": 6.61, "sqlite_median_ms": 2842.26, "sqlite_fastest_ms": 2839.45, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s20-17.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s20-17.jsonl new file mode 100644 index 0000000..7f4348a --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s20-17.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.34, "pure_fastest_ms": 5.3, "sqlite_median_ms": 48.31, "sqlite_fastest_ms": 48.11, "sqlite_indexed_median_ms": 14.32, "sqlite_indexed_fastest_ms": 14.28} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.8, "pure_fastest_ms": 0.77, "sqlite_median_ms": 6.77, "sqlite_fastest_ms": 6.75, "sqlite_indexed_median_ms": 0.2, "sqlite_indexed_fastest_ms": 0.2} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.4, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.68, "sqlite_fastest_ms": 1.66, "sqlite_indexed_median_ms": 1.67, "sqlite_indexed_fastest_ms": 1.67} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.66, "pure_fastest_ms": 6.59, "sqlite_median_ms": 3340.42, "sqlite_fastest_ms": 3333.47, "sqlite_indexed_median_ms": 8.82, "sqlite_indexed_fastest_ms": 8.76} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s20-18.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s20-18.jsonl new file mode 100644 index 0000000..b22341a --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s20-18.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.3, "pure_fastest_ms": 5.19, "sqlite_median_ms": 45.28, "sqlite_fastest_ms": 45.05, "sqlite_indexed_median_ms": 14.1, "sqlite_indexed_fastest_ms": 14.03} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.37, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.73, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2842.24, "sqlite_fastest_ms": 2839.31, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s9-13.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s9-13.jsonl new file mode 100644 index 0000000..a113454 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s9-13.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.21, "pure_fastest_ms": 5.13, "sqlite_median_ms": 45.0, "sqlite_fastest_ms": 44.87, "sqlite_indexed_median_ms": 14.05, "sqlite_indexed_fastest_ms": 14.03} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.77, "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.36, "sqlite_median_ms": 1.49, "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.64, "pure_fastest_ms": 6.58, "sqlite_median_ms": 2838.51, "sqlite_fastest_ms": 2835.42, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.52} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s9-14.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s9-14.jsonl new file mode 100644 index 0000000..785af94 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s9-14.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.18, "pure_fastest_ms": 5.09, "sqlite_median_ms": 47.83, "sqlite_fastest_ms": 47.52, "sqlite_indexed_median_ms": 14.2, "sqlite_indexed_fastest_ms": 14.18} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.81, "pure_fastest_ms": 0.78, "sqlite_median_ms": 6.77, "sqlite_fastest_ms": 6.73, "sqlite_indexed_median_ms": 0.18, "sqlite_indexed_fastest_ms": 0.18} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.36, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.68, "sqlite_fastest_ms": 1.68, "sqlite_indexed_median_ms": 1.68, "sqlite_indexed_fastest_ms": 1.67} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.59, "pure_fastest_ms": 6.52, "sqlite_median_ms": 3342.61, "sqlite_fastest_ms": 3329.2, "sqlite_indexed_median_ms": 8.61, "sqlite_indexed_fastest_ms": 8.58} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s9-15.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s9-15.jsonl new file mode 100644 index 0000000..ea28943 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s9-15.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.13, "pure_fastest_ms": 5.07, "sqlite_median_ms": 48.16, "sqlite_fastest_ms": 48.06, "sqlite_indexed_median_ms": 14.47, "sqlite_indexed_fastest_ms": 14.43} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.79, "pure_fastest_ms": 0.76, "sqlite_median_ms": 6.8, "sqlite_fastest_ms": 6.74, "sqlite_indexed_median_ms": 0.2, "sqlite_indexed_fastest_ms": 0.2} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.48, "pure_fastest_ms": 0.44, "sqlite_median_ms": 1.67, "sqlite_fastest_ms": 1.67, "sqlite_indexed_median_ms": 1.68, "sqlite_indexed_fastest_ms": 1.67} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.65, "pure_fastest_ms": 6.59, "sqlite_median_ms": 3334.39, "sqlite_fastest_ms": 3329.6, "sqlite_indexed_median_ms": 8.76, "sqlite_indexed_fastest_ms": 8.69} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s9-16.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s9-16.jsonl new file mode 100644 index 0000000..77e4906 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s9-16.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.2, "pure_fastest_ms": 5.16, "sqlite_median_ms": 45.29, "sqlite_fastest_ms": 45.17, "sqlite_indexed_median_ms": 14.05, "sqlite_indexed_fastest_ms": 14.04} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "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.38, "pure_fastest_ms": 0.35, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.46, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.7, "pure_fastest_ms": 6.64, "sqlite_median_ms": 2833.02, "sqlite_fastest_ms": 2829.14, "sqlite_indexed_median_ms": 7.67, "sqlite_indexed_fastest_ms": 7.54} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s9-17.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s9-17.jsonl new file mode 100644 index 0000000..73e6798 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s9-17.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.26, "pure_fastest_ms": 5.16, "sqlite_median_ms": 45.36, "sqlite_fastest_ms": 45.11, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 14.01} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.81, "pure_fastest_ms": 0.77, "sqlite_median_ms": 5.89, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.41, "pure_fastest_ms": 0.38, "sqlite_median_ms": 1.49, "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.62, "pure_fastest_ms": 6.56, "sqlite_median_ms": 2839.96, "sqlite_fastest_ms": 2837.11, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.51} diff --git a/research/experiments/040-against-c/2026-10-09-queries-s9-18.jsonl b/research/experiments/040-against-c/2026-10-09-queries-s9-18.jsonl new file mode 100644 index 0000000..a180899 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-queries-s9-18.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.14, "pure_fastest_ms": 5.09, "sqlite_median_ms": 44.99, "sqlite_fastest_ms": 44.76, "sqlite_indexed_median_ms": 14.08, "sqlite_indexed_fastest_ms": 13.98} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.91, "pure_fastest_ms": 0.77, "sqlite_median_ms": 6.08, "sqlite_fastest_ms": 6.05, "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.49, "sqlite_median_ms": 1.66, "sqlite_fastest_ms": 1.61, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 7.61, "pure_fastest_ms": 7.42, "sqlite_median_ms": 2841.77, "sqlite_fastest_ms": 2838.44, "sqlite_indexed_median_ms": 7.68, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s20-13.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s20-13.jsonl new file mode 100644 index 0000000..2f74dd9 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s20-13.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.68, "sqlite_load_s": 1.54, "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": 46612, "new_orders_per_minute": 1246736, "undone_new_orders": 4010, "errors": 0, "new_order": {"done": 419590, "failed": 0, "p50_us": 1344, "p99_us": 3328}, "payment": {"done": 400800, "failed": 0, "p50_us": 1344, "p99_us": 3328}, "order_status": {"done": 37387, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 37325, "failed": 0, "p50_us": 1344, "p99_us": 3328}, "stock_level": {"done": 37132, "failed": 0, "p50_us": 288, "p99_us": 1280}, "server_threads": "3", "cpu_us_per_transaction": 42.2, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 488.4, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 488.4, "pure_state_mib": 246.7, "pure_store_mib": 254.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 29067, "burst_events": 853782, "checkpoints": 42}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s20-14.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s20-14.jsonl new file mode 100644 index 0000000..d5c58ce --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s20-14.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.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": 45779, "new_orders_per_minute": 1224641, "undone_new_orders": 3935, "errors": 0, "new_order": {"done": 412149, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "payment": {"done": 393539, "failed": 0, "p50_us": 1344, "p99_us": 3712}, "order_status": {"done": 36726, "failed": 0, "p50_us": 256, "p99_us": 1280}, "delivery": {"done": 36672, "failed": 0, "p50_us": 1344, "p99_us": 3712}, "stock_level": {"done": 36489, "failed": 0, "p50_us": 288, "p99_us": 1344}, "server_threads": "3", "cpu_us_per_transaction": 42.5, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 480.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 480.0, "pure_state_mib": 242.7, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28384, "burst_events": 838510, "checkpoints": 41}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s20-15.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s20-15.jsonl new file mode 100644 index 0000000..f41a7a0 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s20-15.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.64, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 45767, "new_orders_per_minute": 1224205, "undone_new_orders": 3946, "errors": 0, "new_order": {"done": 412022, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "payment": {"done": 393525, "failed": 0, "p50_us": 1344, "p99_us": 3584}, "order_status": {"done": 36682, "failed": 0, "p50_us": 272, "p99_us": 1280}, "delivery": {"done": 36636, "failed": 0, "p50_us": 1344, "p99_us": 3584}, "stock_level": {"done": 36484, "failed": 0, "p50_us": 304, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 42.4, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 480.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 480.2, "pure_state_mib": 242.6, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28490, "burst_events": 838323, "checkpoints": 41}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s20-16.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s20-16.jsonl new file mode 100644 index 0000000..3daa9b2 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s20-16.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.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": 44335, "new_orders_per_minute": 1186103, "undone_new_orders": 3804, "errors": 0, "new_order": {"done": 399172, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "payment": {"done": 381121, "failed": 0, "p50_us": 1344, "p99_us": 4096}, "order_status": {"done": 35542, "failed": 0, "p50_us": 272, "p99_us": 1600}, "delivery": {"done": 35494, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "stock_level": {"done": 35372, "failed": 0, "p50_us": 304, "p99_us": 1792}, "server_threads": "3", "cpu_us_per_transaction": 43.1, "core_shares": {"pure-owner": 0.87, "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": 27727, "burst_events": 812069, "checkpoints": 40}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s20-17.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s20-17.jsonl new file mode 100644 index 0000000..4badd49 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s20-17.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.66, "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": 45705, "new_orders_per_minute": 1222824, "undone_new_orders": 3933, "errors": 0, "new_order": {"done": 411541, "failed": 0, "p50_us": 1408, "p99_us": 3584}, "payment": {"done": 392907, "failed": 0, "p50_us": 1344, "p99_us": 3584}, "order_status": {"done": 36669, "failed": 0, "p50_us": 272, "p99_us": 1344}, "delivery": {"done": 36546, "failed": 0, "p50_us": 1344, "p99_us": 3456}, "stock_level": {"done": 36437, "failed": 0, "p50_us": 304, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 42.5, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 480.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 480.0, "pure_state_mib": 242.4, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28521, "burst_events": 837146, "checkpoints": 41}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s20-18.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s20-18.jsonl new file mode 100644 index 0000000..3c558cb --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s20-18.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.64, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 45672, "new_orders_per_minute": 1221730, "undone_new_orders": 3921, "errors": 0, "new_order": {"done": 411165, "failed": 0, "p50_us": 1344, "p99_us": 3840}, "payment": {"done": 392629, "failed": 0, "p50_us": 1344, "p99_us": 3840}, "order_status": {"done": 36642, "failed": 0, "p50_us": 272, "p99_us": 1536}, "delivery": {"done": 36574, "failed": 0, "p50_us": 1344, "p99_us": 3840}, "stock_level": {"done": 36425, "failed": 0, "p50_us": 288, "p99_us": 1600}, "server_threads": "3", "cpu_us_per_transaction": 42.6, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 479.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 479.6, "pure_state_mib": 242.2, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28900, "burst_events": 836516, "checkpoints": 41}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s9-13.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s9-13.jsonl new file mode 100644 index 0000000..009b3ab --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s9-13.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.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": 44038, "new_orders_per_minute": 1177835, "undone_new_orders": 3784, "errors": 0, "new_order": {"done": 396397, "failed": 0, "p50_us": 1408, "p99_us": 4352}, "payment": {"done": 378690, "failed": 0, "p50_us": 1344, "p99_us": 4352}, "order_status": {"done": 35329, "failed": 0, "p50_us": 272, "p99_us": 1664}, "delivery": {"done": 35247, "failed": 0, "p50_us": 1344, "p99_us": 4352}, "stock_level": {"done": 35102, "failed": 0, "p50_us": 304, "p99_us": 1792}, "server_threads": "3", "cpu_us_per_transaction": 42.8, "core_shares": {"pure-owner": 0.86, "pure-checkpoint": 0.01}, "resident_mib": 464.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 464.7, "pure_state_mib": 234.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27806, "burst_events": 806634, "checkpoints": 39}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s9-14.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s9-14.jsonl new file mode 100644 index 0000000..7fcceae --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s9-14.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.64, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 45556, "new_orders_per_minute": 1218677, "undone_new_orders": 3912, "errors": 0, "new_order": {"done": 410138, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "payment": {"done": 391603, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "order_status": {"done": 36519, "failed": 0, "p50_us": 256, "p99_us": 1344}, "delivery": {"done": 36494, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "stock_level": {"done": 36359, "failed": 0, "p50_us": 304, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 42.6, "core_shares": {"pure-owner": 0.87, "pure-checkpoint": 0.01}, "resident_mib": 478.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 478.6, "pure_state_mib": 241.6, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28179, "burst_events": 834409, "checkpoints": 40}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s9-15.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s9-15.jsonl new file mode 100644 index 0000000..ce6e980 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s9-15.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.63, "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": 45609, "new_orders_per_minute": 1219983, "undone_new_orders": 3918, "errors": 0, "new_order": {"done": 410579, "failed": 0, "p50_us": 1344, "p99_us": 3840}, "payment": {"done": 392132, "failed": 0, "p50_us": 1344, "p99_us": 3840}, "order_status": {"done": 36578, "failed": 0, "p50_us": 256, "p99_us": 1344}, "delivery": {"done": 36522, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "stock_level": {"done": 36374, "failed": 0, "p50_us": 288, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 42.4, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 478.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 478.7, "pure_state_mib": 241.9, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28142, "burst_events": 835401, "checkpoints": 40}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s9-16.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s9-16.jsonl new file mode 100644 index 0000000..3d69378 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s9-16.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.63, "sqlite_load_s": 1.54, "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": 45559, "new_orders_per_minute": 1218639, "undone_new_orders": 3910, "errors": 0, "new_order": {"done": 410124, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "payment": {"done": 391677, "failed": 0, "p50_us": 1344, "p99_us": 3584}, "order_status": {"done": 36563, "failed": 0, "p50_us": 272, "p99_us": 1408}, "delivery": {"done": 36512, "failed": 0, "p50_us": 1344, "p99_us": 3584}, "stock_level": {"done": 36309, "failed": 0, "p50_us": 304, "p99_us": 1536}, "server_threads": "3", "cpu_us_per_transaction": 43.1, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 478.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 478.9, "pure_state_mib": 241.6, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28663, "burst_events": 834487, "checkpoints": 40}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s9-17.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s9-17.jsonl new file mode 100644 index 0000000..cbe6b48 --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s9-17.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.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": 45286, "new_orders_per_minute": 1211543, "undone_new_orders": 3891, "errors": 0, "new_order": {"done": 407739, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "payment": {"done": 389267, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "order_status": {"done": 36332, "failed": 0, "p50_us": 256, "p99_us": 1280}, "delivery": {"done": 36295, "failed": 0, "p50_us": 1344, "p99_us": 3968}, "stock_level": {"done": 36082, "failed": 0, "p50_us": 288, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 42.6, "core_shares": {"pure-owner": 0.87, "pure-checkpoint": 0.01}, "resident_mib": 475.8, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 475.8, "pure_state_mib": 240.4, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27911, "burst_events": 829490, "checkpoints": 40}} diff --git a/research/experiments/040-against-c/2026-10-09-tpcc-s9-18.jsonl b/research/experiments/040-against-c/2026-10-09-tpcc-s9-18.jsonl new file mode 100644 index 0000000..6ac9dcf --- /dev/null +++ b/research/experiments/040-against-c/2026-10-09-tpcc-s9-18.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.64, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 40.3, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 45305, "new_orders_per_minute": 1212117, "undone_new_orders": 3891, "errors": 0, "new_order": {"done": 407930, "failed": 0, "p50_us": 1344, "p99_us": 3840}, "payment": {"done": 389450, "failed": 0, "p50_us": 1344, "p99_us": 3712}, "order_status": {"done": 36316, "failed": 0, "p50_us": 272, "p99_us": 1408}, "delivery": {"done": 36272, "failed": 0, "p50_us": 1344, "p99_us": 3712}, "stock_level": {"done": 36141, "failed": 0, "p50_us": 304, "p99_us": 1536}, "server_threads": "3", "cpu_us_per_transaction": 43.2, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 476.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 476.2, "pure_state_mib": 240.5, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 28488, "burst_events": 829840, "checkpoints": 40}} diff --git a/research/experiments/041-batches/2026-10-09-counts.jsonl b/research/experiments/041-batches/2026-10-09-counts.jsonl new file mode 100644 index 0000000..fd27cc6 --- /dev/null +++ b/research/experiments/041-batches/2026-10-09-counts.jsonl @@ -0,0 +1,50 @@ +{"version":"b17","way":"batches","work":"bfs","instructions":3372361685,"cycles":1662769271} +{"version":"b17","way":"rounds","work":"bfs","instructions":4711634753,"cycles":2146053261} +{"version":"b17","way":"batches","work":"knapsack","instructions":346249299,"cycles":108294052} +{"version":"b17","way":"rounds","work":"knapsack","instructions":21688102990,"cycles":7537022923} +{"version":"b17","way":"batches","work":"matmul","instructions":722168228,"cycles":243543563} +{"version":"b17","way":"rounds","work":"matmul","instructions":21436716360,"cycles":6622287253} +{"version":"b17","way":"batches","work":"roots","instructions":156270409,"cycles":109357759} +{"version":"b17","way":"rounds","work":"roots","instructions":2755945428,"cycles":987822900} +{"version":"b17","way":"batches","work":"join","instructions":1785480194,"cycles":1045726026} +{"version":"b17","way":"rounds","work":"join","instructions":7669661655,"cycles":3293254442} +{"version":"b18","way":"batches","work":"bfs","instructions":3354780672,"cycles":1678703944} +{"version":"b18","way":"rounds","work":"bfs","instructions":4711634589,"cycles":2158517282} +{"version":"b18","way":"batches","work":"knapsack","instructions":346278917,"cycles":110306318} +{"version":"b18","way":"rounds","work":"knapsack","instructions":21688103033,"cycles":7539558132} +{"version":"b18","way":"batches","work":"matmul","instructions":722169426,"cycles":244273534} +{"version":"b18","way":"rounds","work":"matmul","instructions":21436716136,"cycles":6629417934} +{"version":"b18","way":"batches","work":"roots","instructions":156271065,"cycles":109401152} +{"version":"b18","way":"rounds","work":"roots","instructions":2755945335,"cycles":988017595} +{"version":"b18","way":"batches","work":"join","instructions":1785486888,"cycles":1014201644} +{"version":"b18","way":"rounds","work":"join","instructions":7669661614,"cycles":3274195702} +{"version":"b18a","way":"batches","work":"bfs","instructions":3415214142,"cycles":1654028985} +{"version":"b18a","way":"rounds","work":"bfs","instructions":4756854854,"cycles":2082766502} +{"version":"b18a","way":"batches","work":"knapsack","instructions":348655109,"cycles":104422210} +{"version":"b18a","way":"rounds","work":"knapsack","instructions":21690506067,"cycles":7550381236} +{"version":"b18a","way":"batches","work":"matmul","instructions":738967770,"cycles":239762688} +{"version":"b18a","way":"rounds","work":"matmul","instructions":21438655022,"cycles":6617574225} +{"version":"b18a","way":"batches","work":"roots","instructions":156406511,"cycles":109617310} +{"version":"b18a","way":"rounds","work":"roots","instructions":2755945390,"cycles":988151399} +{"version":"b18a","way":"batches","work":"join","instructions":1817357687,"cycles":1001603947} +{"version":"b18a","way":"rounds","work":"join","instructions":7677309842,"cycles":3308432834} +{"version":"b19","way":"batches","work":"bfs","instructions":3419213280,"cycles":1659846921} +{"version":"b19","way":"rounds","work":"bfs","instructions":4756853584,"cycles":2090971921} +{"version":"b19","way":"batches","work":"knapsack","instructions":348655180,"cycles":104441272} +{"version":"b19","way":"rounds","work":"knapsack","instructions":21690505967,"cycles":7559412712} +{"version":"b19","way":"batches","work":"matmul","instructions":738968020,"cycles":241227046} +{"version":"b19","way":"rounds","work":"matmul","instructions":21438654915,"cycles":6626938337} +{"version":"b19","way":"batches","work":"roots","instructions":156406418,"cycles":109518518} +{"version":"b19","way":"rounds","work":"roots","instructions":2755945412,"cycles":987957693} +{"version":"b19","way":"batches","work":"join","instructions":1817357840,"cycles":994370112} +{"version":"b19","way":"rounds","work":"join","instructions":7677309661,"cycles":3308013838} +{"version":"b20","way":"batches","work":"bfs","instructions":3374694290,"cycles":1667948983} +{"version":"b20","way":"rounds","work":"bfs","instructions":4715631551,"cycles":2085456396} +{"version":"b20","way":"batches","work":"knapsack","instructions":348396437,"cycles":105113739} +{"version":"b20","way":"rounds","work":"knapsack","instructions":21688102987,"cycles":7530407581} +{"version":"b20","way":"batches","work":"matmul","instructions":738920970,"cycles":239616567} +{"version":"b20","way":"rounds","work":"matmul","instructions":21436716426,"cycles":6633313221} +{"version":"b20","way":"batches","work":"roots","instructions":156406480,"cycles":109640251} +{"version":"b20","way":"rounds","work":"roots","instructions":2755945401,"cycles":987942621} +{"version":"b20","way":"batches","work":"join","instructions":1816206410,"cycles":1020698335} +{"version":"b20","way":"rounds","work":"join","instructions":7669661669,"cycles":3290913542} diff --git a/research/experiments/041-batches/2026-10-09-pairs.jsonl b/research/experiments/041-batches/2026-10-09-pairs.jsonl new file mode 100644 index 0000000..bd06a14 --- /dev/null +++ b/research/experiments/041-batches/2026-10-09-pairs.jsonl @@ -0,0 +1,246 @@ +{"version":"b16","way":"batches","turn":1,"work":"roots","pure_median_ms":8.267,"c_median_ms":6.864,"ratio":1.204,"agree":true} +{"version":"b16","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.255,"c_median_ms":6.224,"ratio":1.326,"agree":true} +{"version":"b16","way":"batches","turn":1,"work":"join","pure_median_ms":115.448,"c_median_ms":30.659,"ratio":3.766,"agree":true} +{"version":"b16","way":"batches","turn":1,"work":"matmul","pure_median_ms":26.315,"c_median_ms":7.920,"ratio":3.323,"agree":true} +{"version":"b16","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.897,"c_median_ms":10.029,"ratio":2.383,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"roots","pure_median_ms":8.293,"c_median_ms":6.861,"ratio":1.209,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.915,"c_median_ms":6.318,"ratio":1.411,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"join","pure_median_ms":115.284,"c_median_ms":32.879,"ratio":3.506,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"matmul","pure_median_ms":26.302,"c_median_ms":7.525,"ratio":3.495,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.220,"c_median_ms":10.024,"ratio":2.416,"agree":true} +{"version":"b16","way":"batches","turn":2,"work":"roots","pure_median_ms":8.279,"c_median_ms":6.861,"ratio":1.207,"agree":true} +{"version":"b16","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.251,"c_median_ms":6.230,"ratio":1.324,"agree":true} +{"version":"b16","way":"batches","turn":2,"work":"join","pure_median_ms":114.829,"c_median_ms":34.220,"ratio":3.356,"agree":true} +{"version":"b16","way":"batches","turn":2,"work":"matmul","pure_median_ms":26.257,"c_median_ms":7.514,"ratio":3.494,"agree":true} +{"version":"b16","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.827,"c_median_ms":10.019,"ratio":2.378,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"roots","pure_median_ms":8.293,"c_median_ms":6.864,"ratio":1.208,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.722,"c_median_ms":6.234,"ratio":1.399,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"join","pure_median_ms":109.769,"c_median_ms":31.357,"ratio":3.501,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"matmul","pure_median_ms":26.391,"c_median_ms":7.531,"ratio":3.504,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"bfs","pure_median_ms":24.244,"c_median_ms":9.946,"ratio":2.438,"agree":true} +{"version":"b16","way":"batches","turn":3,"work":"roots","pure_median_ms":8.270,"c_median_ms":6.859,"ratio":1.206,"agree":true} +{"version":"b16","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.271,"c_median_ms":6.225,"ratio":1.329,"agree":true} +{"version":"b16","way":"batches","turn":3,"work":"join","pure_median_ms":117.211,"c_median_ms":33.106,"ratio":3.540,"agree":true} +{"version":"b16","way":"batches","turn":3,"work":"matmul","pure_median_ms":26.278,"c_median_ms":7.821,"ratio":3.360,"agree":true} +{"version":"b16","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.866,"c_median_ms":9.957,"ratio":2.397,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"roots","pure_median_ms":8.290,"c_median_ms":6.870,"ratio":1.207,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.747,"c_median_ms":6.230,"ratio":1.404,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"join","pure_median_ms":111.845,"c_median_ms":32.083,"ratio":3.486,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"matmul","pure_median_ms":26.356,"c_median_ms":7.588,"ratio":3.473,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"bfs","pure_median_ms":27.877,"c_median_ms":10.121,"ratio":2.754,"agree":true} +{"version":"b16","way":"batches","turn":4,"work":"roots","pure_median_ms":8.275,"c_median_ms":6.862,"ratio":1.206,"agree":true} +{"version":"b16","way":"batches","turn":4,"work":"knapsack","pure_median_ms":8.242,"c_median_ms":6.225,"ratio":1.324,"agree":true} +{"version":"b16","way":"batches","turn":4,"work":"join","pure_median_ms":113.759,"c_median_ms":30.151,"ratio":3.773,"agree":true} +{"version":"b16","way":"batches","turn":4,"work":"matmul","pure_median_ms":26.227,"c_median_ms":7.528,"ratio":3.484,"agree":true} +{"version":"b16","way":"batches","turn":4,"work":"bfs","pure_median_ms":24.064,"c_median_ms":9.960,"ratio":2.416,"agree":true} +{"version":"b17","way":"batches","turn":4,"work":"roots","pure_median_ms":8.284,"c_median_ms":6.876,"ratio":1.205,"agree":true} +{"version":"b17","way":"batches","turn":4,"work":"knapsack","pure_median_ms":8.736,"c_median_ms":6.229,"ratio":1.403,"agree":true} +{"version":"b17","way":"batches","turn":4,"work":"join","pure_median_ms":117.599,"c_median_ms":34.006,"ratio":3.458,"agree":true} +{"version":"b17","way":"batches","turn":4,"work":"matmul","pure_median_ms":26.413,"c_median_ms":7.897,"ratio":3.345,"agree":true} +{"version":"b17","way":"batches","turn":4,"work":"bfs","pure_median_ms":24.196,"c_median_ms":10.081,"ratio":2.400,"agree":true} +{"version":"b16","way":"batches","turn":5,"work":"roots","pure_median_ms":8.283,"c_median_ms":6.866,"ratio":1.206,"agree":true} +{"version":"b16","way":"batches","turn":5,"work":"knapsack","pure_median_ms":8.297,"c_median_ms":6.236,"ratio":1.331,"agree":true} +{"version":"b16","way":"batches","turn":5,"work":"join","pure_median_ms":117.200,"c_median_ms":31.838,"ratio":3.681,"agree":true} +{"version":"b16","way":"batches","turn":5,"work":"matmul","pure_median_ms":26.311,"c_median_ms":7.608,"ratio":3.458,"agree":true} +{"version":"b16","way":"batches","turn":5,"work":"bfs","pure_median_ms":23.928,"c_median_ms":10.094,"ratio":2.371,"agree":true} +{"version":"b17","way":"batches","turn":5,"work":"roots","pure_median_ms":8.279,"c_median_ms":6.863,"ratio":1.206,"agree":true} +{"version":"b17","way":"batches","turn":5,"work":"knapsack","pure_median_ms":8.727,"c_median_ms":6.222,"ratio":1.403,"agree":true} +{"version":"b17","way":"batches","turn":5,"work":"join","pure_median_ms":110.546,"c_median_ms":29.922,"ratio":3.694,"agree":true} +{"version":"b17","way":"batches","turn":5,"work":"matmul","pure_median_ms":26.300,"c_median_ms":7.543,"ratio":3.487,"agree":true} +{"version":"b17","way":"batches","turn":5,"work":"bfs","pure_median_ms":23.826,"c_median_ms":10.263,"ratio":2.322,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"roots","pure_median_ms":8.326,"c_median_ms":6.879,"ratio":1.210,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.758,"c_median_ms":6.230,"ratio":1.406,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"join","pure_median_ms":111.714,"c_median_ms":33.066,"ratio":3.379,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"matmul","pure_median_ms":26.229,"c_median_ms":7.533,"ratio":3.482,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.265,"c_median_ms":10.099,"ratio":2.304,"agree":true} +{"version":"b18a","way":"batches","turn":1,"work":"roots","pure_median_ms":8.299,"c_median_ms":6.857,"ratio":1.210,"agree":true} +{"version":"b18a","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.180,"c_median_ms":6.231,"ratio":1.313,"agree":true} +{"version":"b18a","way":"batches","turn":1,"work":"join","pure_median_ms":110.048,"c_median_ms":31.209,"ratio":3.526,"agree":true} +{"version":"b18a","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.831,"c_median_ms":7.754,"ratio":3.331,"agree":true} +{"version":"b18a","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.285,"c_median_ms":10.063,"ratio":2.314,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"roots","pure_median_ms":8.281,"c_median_ms":6.868,"ratio":1.206,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.749,"c_median_ms":6.230,"ratio":1.404,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"join","pure_median_ms":116.691,"c_median_ms":31.788,"ratio":3.671,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"matmul","pure_median_ms":26.446,"c_median_ms":8.297,"ratio":3.188,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.441,"c_median_ms":10.001,"ratio":2.344,"agree":true} +{"version":"b18a","way":"batches","turn":2,"work":"roots","pure_median_ms":8.292,"c_median_ms":6.866,"ratio":1.208,"agree":true} +{"version":"b18a","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.182,"c_median_ms":6.227,"ratio":1.314,"agree":true} +{"version":"b18a","way":"batches","turn":2,"work":"join","pure_median_ms":113.431,"c_median_ms":32.117,"ratio":3.532,"agree":true} +{"version":"b18a","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.748,"c_median_ms":7.544,"ratio":3.413,"agree":true} +{"version":"b18a","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.102,"c_median_ms":9.948,"ratio":2.322,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"roots","pure_median_ms":8.279,"c_median_ms":6.861,"ratio":1.207,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.724,"c_median_ms":6.226,"ratio":1.401,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"join","pure_median_ms":109.634,"c_median_ms":31.164,"ratio":3.518,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"matmul","pure_median_ms":26.243,"c_median_ms":7.554,"ratio":3.474,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.406,"c_median_ms":10.073,"ratio":2.324,"agree":true} +{"version":"b18a","way":"batches","turn":3,"work":"roots","pure_median_ms":8.294,"c_median_ms":6.867,"ratio":1.208,"agree":true} +{"version":"b18a","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.203,"c_median_ms":6.230,"ratio":1.317,"agree":true} +{"version":"b18a","way":"batches","turn":3,"work":"join","pure_median_ms":111.484,"c_median_ms":30.335,"ratio":3.675,"agree":true} +{"version":"b18a","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.820,"c_median_ms":7.936,"ratio":3.254,"agree":true} +{"version":"b18a","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.528,"c_median_ms":10.032,"ratio":2.345,"agree":true} +{"version":"b18","way":"batches","turn":4,"work":"roots","pure_median_ms":8.280,"c_median_ms":6.862,"ratio":1.207,"agree":true} +{"version":"b18","way":"batches","turn":4,"work":"knapsack","pure_median_ms":8.732,"c_median_ms":6.227,"ratio":1.402,"agree":true} +{"version":"b18","way":"batches","turn":4,"work":"join","pure_median_ms":111.086,"c_median_ms":31.492,"ratio":3.527,"agree":true} +{"version":"b18","way":"batches","turn":4,"work":"matmul","pure_median_ms":26.277,"c_median_ms":7.561,"ratio":3.475,"agree":true} +{"version":"b18","way":"batches","turn":4,"work":"bfs","pure_median_ms":23.694,"c_median_ms":10.159,"ratio":2.332,"agree":true} +{"version":"b18a","way":"batches","turn":4,"work":"roots","pure_median_ms":8.294,"c_median_ms":6.866,"ratio":1.208,"agree":true} +{"version":"b18a","way":"batches","turn":4,"work":"knapsack","pure_median_ms":8.211,"c_median_ms":6.230,"ratio":1.318,"agree":true} +{"version":"b18a","way":"batches","turn":4,"work":"join","pure_median_ms":112.167,"c_median_ms":31.202,"ratio":3.595,"agree":true} +{"version":"b18a","way":"batches","turn":4,"work":"matmul","pure_median_ms":25.731,"c_median_ms":7.532,"ratio":3.416,"agree":true} +{"version":"b18a","way":"batches","turn":4,"work":"bfs","pure_median_ms":24.308,"c_median_ms":11.484,"ratio":2.117,"agree":true} +{"version":"b18","way":"batches","turn":5,"work":"roots","pure_median_ms":8.278,"c_median_ms":6.865,"ratio":1.206,"agree":true} +{"version":"b18","way":"batches","turn":5,"work":"knapsack","pure_median_ms":8.739,"c_median_ms":6.234,"ratio":1.402,"agree":true} +{"version":"b18","way":"batches","turn":5,"work":"join","pure_median_ms":111.430,"c_median_ms":32.352,"ratio":3.444,"agree":true} +{"version":"b18","way":"batches","turn":5,"work":"matmul","pure_median_ms":26.243,"c_median_ms":7.526,"ratio":3.487,"agree":true} +{"version":"b18","way":"batches","turn":5,"work":"bfs","pure_median_ms":23.667,"c_median_ms":10.002,"ratio":2.366,"agree":true} +{"version":"b18a","way":"batches","turn":5,"work":"roots","pure_median_ms":8.300,"c_median_ms":6.870,"ratio":1.208,"agree":true} +{"version":"b18a","way":"batches","turn":5,"work":"knapsack","pure_median_ms":8.236,"c_median_ms":6.234,"ratio":1.321,"agree":true} +{"version":"b18a","way":"batches","turn":5,"work":"join","pure_median_ms":111.445,"c_median_ms":30.545,"ratio":3.649,"agree":true} +{"version":"b18a","way":"batches","turn":5,"work":"matmul","pure_median_ms":25.771,"c_median_ms":7.584,"ratio":3.398,"agree":true} +{"version":"b18a","way":"batches","turn":5,"work":"bfs","pure_median_ms":22.890,"c_median_ms":10.273,"ratio":2.228,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.690,"c_median_ms":6.232,"ratio":1.394,"agree":true} +{"version":"b17","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.232,"c_median_ms":10.041,"ratio":2.413,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"knapsack","pure_median_ms":9.299,"c_median_ms":6.430,"ratio":1.446,"agree":true} +{"version":"b18","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.536,"c_median_ms":10.004,"ratio":2.353,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.739,"c_median_ms":6.232,"ratio":1.402,"agree":true} +{"version":"b17","way":"batches","turn":2,"work":"bfs","pure_median_ms":24.246,"c_median_ms":10.206,"ratio":2.376,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.701,"c_median_ms":6.227,"ratio":1.397,"agree":true} +{"version":"b18","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.928,"c_median_ms":10.066,"ratio":2.377,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.750,"c_median_ms":6.232,"ratio":1.404,"agree":true} +{"version":"b17","way":"batches","turn":3,"work":"bfs","pure_median_ms":24.789,"c_median_ms":10.091,"ratio":2.457,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.762,"c_median_ms":6.281,"ratio":1.395,"agree":true} +{"version":"b18","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.577,"c_median_ms":10.064,"ratio":2.343,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"roots","pure_median_ms":8.958,"c_median_ms":6.871,"ratio":1.304,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"knapsack","pure_median_ms":11.400,"c_median_ms":6.225,"ratio":1.831,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"sort","pure_median_ms":58.200,"c_median_ms":26.907,"ratio":2.163,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"join","pure_median_ms":122.351,"c_median_ms":30.111,"ratio":4.063,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"words","pure_median_ms":215.824,"c_median_ms":38.556,"ratio":5.598,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"matmul","pure_median_ms":39.954,"c_median_ms":7.523,"ratio":5.311,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.149,"c_median_ms":10.002,"ratio":2.414,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"roots","pure_median_ms":8.292,"c_median_ms":6.861,"ratio":1.208,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.263,"c_median_ms":6.227,"ratio":1.327,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"sort","pure_median_ms":57.109,"c_median_ms":26.882,"ratio":2.124,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"join","pure_median_ms":112.788,"c_median_ms":31.889,"ratio":3.537,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"words","pure_median_ms":218.230,"c_median_ms":37.574,"ratio":5.808,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.725,"c_median_ms":7.867,"ratio":3.270,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.133,"c_median_ms":10.181,"ratio":2.272,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"roots","pure_median_ms":8.974,"c_median_ms":6.863,"ratio":1.308,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"knapsack","pure_median_ms":11.472,"c_median_ms":6.236,"ratio":1.840,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"sort","pure_median_ms":56.924,"c_median_ms":26.881,"ratio":2.118,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"join","pure_median_ms":121.237,"c_median_ms":29.843,"ratio":4.062,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"words","pure_median_ms":213.988,"c_median_ms":38.420,"ratio":5.570,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"matmul","pure_median_ms":40.026,"c_median_ms":8.064,"ratio":4.964,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"bfs","pure_median_ms":24.298,"c_median_ms":10.115,"ratio":2.402,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"roots","pure_median_ms":8.292,"c_median_ms":6.867,"ratio":1.208,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.200,"c_median_ms":6.225,"ratio":1.317,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"sort","pure_median_ms":56.938,"c_median_ms":26.916,"ratio":2.115,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"join","pure_median_ms":110.755,"c_median_ms":30.315,"ratio":3.654,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"words","pure_median_ms":217.238,"c_median_ms":39.112,"ratio":5.554,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.766,"c_median_ms":7.535,"ratio":3.420,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.399,"c_median_ms":10.060,"ratio":2.326,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"roots","pure_median_ms":8.963,"c_median_ms":6.871,"ratio":1.305,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"knapsack","pure_median_ms":11.439,"c_median_ms":6.229,"ratio":1.836,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"sort","pure_median_ms":57.778,"c_median_ms":26.960,"ratio":2.143,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"join","pure_median_ms":119.053,"c_median_ms":30.341,"ratio":3.924,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"words","pure_median_ms":215.859,"c_median_ms":40.440,"ratio":5.338,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"matmul","pure_median_ms":39.949,"c_median_ms":7.529,"ratio":5.306,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"bfs","pure_median_ms":24.057,"c_median_ms":10.089,"ratio":2.385,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"roots","pure_median_ms":8.309,"c_median_ms":6.869,"ratio":1.210,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.205,"c_median_ms":6.231,"ratio":1.317,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"sort","pure_median_ms":57.273,"c_median_ms":26.864,"ratio":2.132,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"join","pure_median_ms":109.361,"c_median_ms":31.111,"ratio":3.515,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"words","pure_median_ms":218.364,"c_median_ms":39.240,"ratio":5.565,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.744,"c_median_ms":8.234,"ratio":3.127,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.171,"c_median_ms":9.917,"ratio":2.336,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"roots","pure_median_ms":8.295,"c_median_ms":6.862,"ratio":1.209,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.197,"c_median_ms":6.225,"ratio":1.317,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"join","pure_median_ms":116.152,"c_median_ms":33.290,"ratio":3.489,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.680,"c_median_ms":7.509,"ratio":3.420,"agree":true} +{"version":"b19","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.083,"c_median_ms":10.201,"ratio":2.263,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"roots","pure_median_ms":8.295,"c_median_ms":6.865,"ratio":1.208,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.210,"c_median_ms":6.245,"ratio":1.315,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"join","pure_median_ms":110.403,"c_median_ms":29.169,"ratio":3.785,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.804,"c_median_ms":7.519,"ratio":3.432,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.353,"c_median_ms":9.954,"ratio":2.346,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"roots","pure_median_ms":8.297,"c_median_ms":6.861,"ratio":1.209,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.225,"c_median_ms":6.224,"ratio":1.321,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"join","pure_median_ms":113.403,"c_median_ms":29.971,"ratio":3.784,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.762,"c_median_ms":7.508,"ratio":3.431,"agree":true} +{"version":"b19","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.043,"c_median_ms":9.971,"ratio":2.311,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"roots","pure_median_ms":8.294,"c_median_ms":6.867,"ratio":1.208,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.198,"c_median_ms":6.226,"ratio":1.317,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"join","pure_median_ms":112.222,"c_median_ms":31.045,"ratio":3.615,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.746,"c_median_ms":7.553,"ratio":3.409,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.206,"c_median_ms":9.975,"ratio":2.326,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"roots","pure_median_ms":8.304,"c_median_ms":6.866,"ratio":1.209,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.219,"c_median_ms":6.228,"ratio":1.320,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"join","pure_median_ms":110.355,"c_median_ms":32.475,"ratio":3.398,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.830,"c_median_ms":7.540,"ratio":3.426,"agree":true} +{"version":"b19","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.315,"c_median_ms":9.919,"ratio":2.350,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"roots","pure_median_ms":8.287,"c_median_ms":6.866,"ratio":1.207,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.170,"c_median_ms":6.233,"ratio":1.311,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"join","pure_median_ms":109.037,"c_median_ms":31.893,"ratio":3.419,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.862,"c_median_ms":7.566,"ratio":3.418,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.027,"c_median_ms":9.955,"ratio":2.313,"agree":true} +{"version":"b19","way":"batches","turn":4,"work":"roots","pure_median_ms":8.298,"c_median_ms":6.871,"ratio":1.208,"agree":true} +{"version":"b19","way":"batches","turn":4,"work":"knapsack","pure_median_ms":8.196,"c_median_ms":6.227,"ratio":1.316,"agree":true} +{"version":"b19","way":"batches","turn":4,"work":"join","pure_median_ms":109.268,"c_median_ms":32.774,"ratio":3.334,"agree":true} +{"version":"b19","way":"batches","turn":4,"work":"matmul","pure_median_ms":25.769,"c_median_ms":7.523,"ratio":3.425,"agree":true} +{"version":"b19","way":"batches","turn":4,"work":"bfs","pure_median_ms":23.085,"c_median_ms":9.890,"ratio":2.334,"agree":true} +{"version":"b20","way":"batches","turn":4,"work":"roots","pure_median_ms":8.288,"c_median_ms":6.864,"ratio":1.207,"agree":true} +{"version":"b20","way":"batches","turn":4,"work":"knapsack","pure_median_ms":8.191,"c_median_ms":6.229,"ratio":1.315,"agree":true} +{"version":"b20","way":"batches","turn":4,"work":"join","pure_median_ms":110.643,"c_median_ms":30.878,"ratio":3.583,"agree":true} +{"version":"b20","way":"batches","turn":4,"work":"matmul","pure_median_ms":25.847,"c_median_ms":7.574,"ratio":3.413,"agree":true} +{"version":"b20","way":"batches","turn":4,"work":"bfs","pure_median_ms":23.049,"c_median_ms":9.946,"ratio":2.317,"agree":true} +{"version":"b19","way":"batches","turn":5,"work":"roots","pure_median_ms":8.291,"c_median_ms":6.865,"ratio":1.208,"agree":true} +{"version":"b19","way":"batches","turn":5,"work":"knapsack","pure_median_ms":8.191,"c_median_ms":6.224,"ratio":1.316,"agree":true} +{"version":"b19","way":"batches","turn":5,"work":"join","pure_median_ms":110.978,"c_median_ms":31.351,"ratio":3.540,"agree":true} +{"version":"b19","way":"batches","turn":5,"work":"matmul","pure_median_ms":25.771,"c_median_ms":7.537,"ratio":3.419,"agree":true} +{"version":"b19","way":"batches","turn":5,"work":"bfs","pure_median_ms":22.905,"c_median_ms":9.952,"ratio":2.301,"agree":true} +{"version":"b20","way":"batches","turn":5,"work":"roots","pure_median_ms":8.298,"c_median_ms":6.864,"ratio":1.209,"agree":true} +{"version":"b20","way":"batches","turn":5,"work":"knapsack","pure_median_ms":8.201,"c_median_ms":6.227,"ratio":1.317,"agree":true} +{"version":"b20","way":"batches","turn":5,"work":"join","pure_median_ms":109.204,"c_median_ms":31.332,"ratio":3.485,"agree":true} +{"version":"b20","way":"batches","turn":5,"work":"matmul","pure_median_ms":25.797,"c_median_ms":7.530,"ratio":3.426,"agree":true} +{"version":"b20","way":"batches","turn":5,"work":"bfs","pure_median_ms":23.223,"c_median_ms":9.946,"ratio":2.335,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"roots","pure_median_ms":8.973,"c_median_ms":6.864,"ratio":1.307,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"knapsack","pure_median_ms":11.476,"c_median_ms":6.228,"ratio":1.843,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"sort","pure_median_ms":55.942,"c_median_ms":26.895,"ratio":2.080,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"join","pure_median_ms":117.696,"c_median_ms":30.614,"ratio":3.845,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"words","pure_median_ms":213.361,"c_median_ms":38.825,"ratio":5.495,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"matmul","pure_median_ms":39.955,"c_median_ms":8.112,"ratio":4.925,"agree":true} +{"version":"b9","way":"batches","turn":1,"work":"bfs","pure_median_ms":24.153,"c_median_ms":9.898,"ratio":2.440,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"roots","pure_median_ms":8.289,"c_median_ms":6.863,"ratio":1.208,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"knapsack","pure_median_ms":8.183,"c_median_ms":6.227,"ratio":1.314,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"sort","pure_median_ms":56.175,"c_median_ms":26.923,"ratio":2.087,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"join","pure_median_ms":111.044,"c_median_ms":31.599,"ratio":3.514,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"words","pure_median_ms":218.102,"c_median_ms":38.733,"ratio":5.631,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"matmul","pure_median_ms":25.714,"c_median_ms":7.544,"ratio":3.409,"agree":true} +{"version":"b20","way":"batches","turn":1,"work":"bfs","pure_median_ms":23.229,"c_median_ms":9.901,"ratio":2.346,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"roots","pure_median_ms":8.970,"c_median_ms":6.872,"ratio":1.305,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"knapsack","pure_median_ms":11.419,"c_median_ms":6.228,"ratio":1.834,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"sort","pure_median_ms":55.817,"c_median_ms":26.899,"ratio":2.075,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"join","pure_median_ms":119.041,"c_median_ms":32.972,"ratio":3.610,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"words","pure_median_ms":214.026,"c_median_ms":38.285,"ratio":5.590,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"matmul","pure_median_ms":40.001,"c_median_ms":7.554,"ratio":5.295,"agree":true} +{"version":"b9","way":"batches","turn":2,"work":"bfs","pure_median_ms":24.252,"c_median_ms":9.892,"ratio":2.452,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"roots","pure_median_ms":8.302,"c_median_ms":6.866,"ratio":1.209,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"knapsack","pure_median_ms":8.208,"c_median_ms":6.231,"ratio":1.317,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"sort","pure_median_ms":55.863,"c_median_ms":26.928,"ratio":2.075,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"join","pure_median_ms":110.880,"c_median_ms":31.843,"ratio":3.482,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"words","pure_median_ms":216.515,"c_median_ms":39.203,"ratio":5.523,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"matmul","pure_median_ms":25.747,"c_median_ms":7.529,"ratio":3.420,"agree":true} +{"version":"b20","way":"batches","turn":2,"work":"bfs","pure_median_ms":23.078,"c_median_ms":9.908,"ratio":2.329,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"roots","pure_median_ms":8.957,"c_median_ms":6.862,"ratio":1.305,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"knapsack","pure_median_ms":11.440,"c_median_ms":6.233,"ratio":1.835,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"sort","pure_median_ms":55.707,"c_median_ms":26.882,"ratio":2.072,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"join","pure_median_ms":119.493,"c_median_ms":31.648,"ratio":3.776,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"words","pure_median_ms":215.632,"c_median_ms":39.222,"ratio":5.498,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"matmul","pure_median_ms":39.989,"c_median_ms":7.555,"ratio":5.293,"agree":true} +{"version":"b9","way":"batches","turn":3,"work":"bfs","pure_median_ms":24.153,"c_median_ms":9.915,"ratio":2.436,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"roots","pure_median_ms":8.289,"c_median_ms":6.867,"ratio":1.207,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"knapsack","pure_median_ms":8.178,"c_median_ms":6.221,"ratio":1.315,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"sort","pure_median_ms":55.745,"c_median_ms":26.858,"ratio":2.076,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"join","pure_median_ms":109.806,"c_median_ms":32.546,"ratio":3.374,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"words","pure_median_ms":217.701,"c_median_ms":40.009,"ratio":5.441,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"matmul","pure_median_ms":25.751,"c_median_ms":7.543,"ratio":3.414,"agree":true} +{"version":"b20","way":"batches","turn":3,"work":"bfs","pure_median_ms":23.663,"c_median_ms":9.930,"ratio":2.383,"agree":true} diff --git a/research/experiments/041-batches/runs.sh b/research/experiments/041-batches/runs.sh index 4da74fb..ba168b9 100755 --- a/research/experiments/041-batches/runs.sh +++ b/research/experiments/041-batches/runs.sh @@ -67,3 +67,5 @@ esac # 2026-10-08-batch-costs.jsonl (design 025): knapsack's time a round by # function and line, b9's code at BATCH 1024 and 256 under a 2 kHz sampled # profile (ms by the in-process C's samples); sum0's times at both. +# A series run over midnight writes two days' files (2026-10-08 and +# 2026-10-09 for design 025's stage 5): read both. |