diff options
Diffstat (limited to 'research/experiments/040-against-c')
27 files changed, 104 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}} |