diff options
Diffstat (limited to 'research/experiments/025-i64-cost/fc65d66')
25 files changed, 96 insertions, 0 deletions
diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-load.txt b/research/experiments/025-i64-cost/fc65d66/2026-09-30-load.txt new file mode 100644 index 0000000..961d1b7 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-load.txt @@ -0,0 +1,12 @@ +1 before 16:39:53 up 1 day, 19:52, 3 users, load average: 0.37, 0.47, 1.03 +1 after 16:41:20 up 1 day, 19:53, 3 users, load average: 0.90, 0.64, 1.04 +2 after 16:42:47 up 1 day, 19:55, 3 users, load average: 1.35, 0.91, 1.10 +2 before 16:44:13 up 1 day, 19:56, 3 users, load average: 1.46, 1.12, 1.16 +3 before 16:45:39 up 1 day, 19:58, 3 users, load average: 1.51, 1.27, 1.21 +3 after 16:47:05 up 1 day, 19:59, 3 users, load average: 1.57, 1.41, 1.27 +4 after 16:48:31 up 1 day, 20:00, 3 users, load average: 1.63, 1.54, 1.33 +4 before 16:49:58 up 1 day, 20:02, 3 users, load average: 1.77, 1.62, 1.38 +5 before 16:51:25 up 1 day, 20:03, 3 users, load average: 1.38, 1.57, 1.38 +5 after 16:52:51 up 1 day, 20:05, 3 users, load average: 1.39, 1.57, 1.40 +6 after 16:54:17 up 1 day, 20:06, 3 users, load average: 1.43, 1.58, 1.42 +6 before 16:55:43 up 1 day, 20:08, 3 users, load average: 1.70, 1.67, 1.47 diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-1-linux-aarch64.jsonl new file mode 100644 index 0000000..b7ac04d --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-1-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.32, "pure_fastest_ms": 5.23, "sqlite_median_ms": 45.37, "sqlite_fastest_ms": 45.16, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.09} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.8, "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.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.85, "pure_fastest_ms": 6.79, "sqlite_median_ms": 2833.5, "sqlite_fastest_ms": 2830.55, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-2-linux-aarch64.jsonl new file mode 100644 index 0000000..3ddcd9b --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-2-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.19, "pure_fastest_ms": 5.15, "sqlite_median_ms": 45.26, "sqlite_fastest_ms": 45.13, "sqlite_indexed_median_ms": 14.13, "sqlite_indexed_fastest_ms": 14.05} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.73, "pure_fastest_ms": 6.69, "sqlite_median_ms": 2836.32, "sqlite_fastest_ms": 2829.35, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-3-linux-aarch64.jsonl new file mode 100644 index 0000000..2e2f3bb --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-3-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.14, "sqlite_median_ms": 45.04, "sqlite_fastest_ms": 44.92, "sqlite_indexed_median_ms": 13.94, "sqlite_indexed_fastest_ms": 13.93} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.8, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.89, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.47, "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.82, "pure_fastest_ms": 6.76, "sqlite_median_ms": 2831.03, "sqlite_fastest_ms": 2829.06, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-4-linux-aarch64.jsonl new file mode 100644 index 0000000..d19011b --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-4-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.28, "pure_fastest_ms": 5.24, "sqlite_median_ms": 45.33, "sqlite_fastest_ms": 45.1, "sqlite_indexed_median_ms": 14.09, "sqlite_indexed_fastest_ms": 14.04} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.83, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.15} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.51, "sqlite_indexed_fastest_ms": 1.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.85, "pure_fastest_ms": 6.77, "sqlite_median_ms": 2835.63, "sqlite_fastest_ms": 2831.04, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.51} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-5-linux-aarch64.jsonl new file mode 100644 index 0000000..89036cb --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-5-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.41, "pure_fastest_ms": 5.29, "sqlite_median_ms": 44.93, "sqlite_fastest_ms": 44.86, "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.81, "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.38, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.51, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.76, "pure_fastest_ms": 6.72, "sqlite_median_ms": 2832.88, "sqlite_fastest_ms": 2828.84, "sqlite_indexed_median_ms": 7.52, "sqlite_indexed_fastest_ms": 7.49} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-6-linux-aarch64.jsonl new file mode 100644 index 0000000..3bff479 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-6-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.33, "pure_fastest_ms": 5.25, "sqlite_median_ms": 44.94, "sqlite_fastest_ms": 44.7, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 14.03} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.95, "pure_fastest_ms": 0.84, "sqlite_median_ms": 7.83, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.86, "pure_fastest_ms": 6.75, "sqlite_median_ms": 2836.5, "sqlite_fastest_ms": 2829.49, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-1-linux-aarch64.jsonl new file mode 100644 index 0000000..2e99769 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-1-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.28, "pure_fastest_ms": 5.21, "sqlite_median_ms": 45.38, "sqlite_fastest_ms": 45.26, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.1} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "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.37, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.72, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2841.33, "sqlite_fastest_ms": 2833.37, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-2-linux-aarch64.jsonl new file mode 100644 index 0000000..9a42524 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-2-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.33, "pure_fastest_ms": 5.19, "sqlite_median_ms": 45.31, "sqlite_fastest_ms": 45.15, "sqlite_indexed_median_ms": 14.0, "sqlite_indexed_fastest_ms": 13.97} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.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.7, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2832.6, "sqlite_fastest_ms": 2831.26, "sqlite_indexed_median_ms": 7.52, "sqlite_indexed_fastest_ms": 7.49} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-3-linux-aarch64.jsonl new file mode 100644 index 0000000..6760f3e --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-3-linux-aarch64.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": 44.96, "sqlite_fastest_ms": 44.82, "sqlite_indexed_median_ms": 14.04, "sqlite_indexed_fastest_ms": 14.01} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.68, "pure_fastest_ms": 6.62, "sqlite_median_ms": 2830.7, "sqlite_fastest_ms": 2828.39, "sqlite_indexed_median_ms": 7.52, "sqlite_indexed_fastest_ms": 7.49} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-4-linux-aarch64.jsonl new file mode 100644 index 0000000..d5984c6 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-4-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.3, "pure_fastest_ms": 5.23, "sqlite_median_ms": 45.27, "sqlite_fastest_ms": 45.16, "sqlite_indexed_median_ms": 14.05, "sqlite_indexed_fastest_ms": 13.94} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "pure_fastest_ms": 0.82, "sqlite_median_ms": 5.87, "sqlite_fastest_ms": 5.85, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.67, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2829.96, "sqlite_fastest_ms": 2827.42, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.55} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-5-linux-aarch64.jsonl new file mode 100644 index 0000000..f62b096 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-5-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.12, "pure_fastest_ms": 5.06, "sqlite_median_ms": 45.26, "sqlite_fastest_ms": 45.11, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.1} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.86, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.37, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.75, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2830.31, "sqlite_fastest_ms": 2828.07, "sqlite_indexed_median_ms": 7.63, "sqlite_indexed_fastest_ms": 7.6} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-6-linux-aarch64.jsonl new file mode 100644 index 0000000..22125d5 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-6-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.26, "pure_fastest_ms": 5.2, "sqlite_median_ms": 45.24, "sqlite_fastest_ms": 45.15, "sqlite_indexed_median_ms": 13.96, "sqlite_indexed_fastest_ms": 13.91} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.82, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.4, "pure_fastest_ms": 0.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.66, "pure_fastest_ms": 6.62, "sqlite_median_ms": 2829.63, "sqlite_fastest_ms": 2827.5, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.52} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-1-linux-aarch64.jsonl new file mode 100644 index 0000000..b44ef51 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-1-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 42974, "new_orders_per_minute": 1149903, "undone_new_orders": 3672, "errors": 0, "new_order": {"done": 386978, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 369343, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "order_status": {"done": 34499, "failed": 0, "p50_us": 256, "p99_us": 1408}, "delivery": {"done": 34435, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "stock_level": {"done": 34246, "failed": 0, "p50_us": 304, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 44.9, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 450.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 450.6, "pure_state_mib": 229.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26442, "burst_events": 787169, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-2-linux-aarch64.jsonl new file mode 100644 index 0000000..64c22fd --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-2-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43683, "new_orders_per_minute": 1168830, "undone_new_orders": 3742, "errors": 0, "new_order": {"done": 393352, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 375476, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "order_status": {"done": 35039, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 34980, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "stock_level": {"done": 34816, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 43.7, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 457.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 457.2, "pure_state_mib": 232.7, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26166, "burst_events": 800149, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-3-linux-aarch64.jsonl new file mode 100644 index 0000000..6c8ba8f --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-3-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.74, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44502, "new_orders_per_minute": 1190503, "undone_new_orders": 3819, "errors": 0, "new_order": {"done": 400657, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "payment": {"done": 382580, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "order_status": {"done": 35684, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35645, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "stock_level": {"done": 35486, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 44.0, "core_shares": {"pure-owner": 0.92, "pure-checkpoint": 0.01}, "resident_mib": 464.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 464.9, "pure_state_mib": 236.6, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26922, "burst_events": 815146, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-4-linux-aarch64.jsonl new file mode 100644 index 0000000..f0664d4 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-4-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43816, "new_orders_per_minute": 1172616, "undone_new_orders": 3747, "errors": 0, "new_order": {"done": 394622, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "payment": {"done": 376572, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "order_status": {"done": 35112, "failed": 0, "p50_us": 256, "p99_us": 1152}, "delivery": {"done": 35080, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "stock_level": {"done": 34945, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 44.5, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 458.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 458.6, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26449, "burst_events": 802612, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-5-linux-aarch64.jsonl new file mode 100644 index 0000000..cc47846 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-5-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.62, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43592, "new_orders_per_minute": 1166465, "undone_new_orders": 3728, "errors": 0, "new_order": {"done": 392550, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "payment": {"done": 374699, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "order_status": {"done": 34950, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 34905, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "stock_level": {"done": 34737, "failed": 0, "p50_us": 288, "p99_us": 1344}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 458.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 458.0, "pure_state_mib": 232.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26417, "burst_events": 798505, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-6-linux-aarch64.jsonl new file mode 100644 index 0000000..46b1321 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-6-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.6, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44342, "new_orders_per_minute": 1186477, "undone_new_orders": 3797, "errors": 0, "new_order": {"done": 399291, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "payment": {"done": 381121, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "order_status": {"done": 35570, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35482, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "stock_level": {"done": 35370, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 43.9, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 464.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 464.0, "pure_state_mib": 235.9, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26550, "burst_events": 812182, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-1-linux-aarch64.jsonl new file mode 100644 index 0000000..32c80d5 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-1-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 42603, "new_orders_per_minute": 1139756, "undone_new_orders": 3639, "errors": 0, "new_order": {"done": 383561, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "payment": {"done": 366218, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "order_status": {"done": 34220, "failed": 0, "p50_us": 256, "p99_us": 1280}, "delivery": {"done": 34112, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "stock_level": {"done": 33955, "failed": 0, "p50_us": 288, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 44.2, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 447.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 447.9, "pure_state_mib": 227.4, "pure_store_mib": 230.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 25994, "burst_events": 780336, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-2-linux-aarch64.jsonl new file mode 100644 index 0000000..f604356 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-2-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44695, "new_orders_per_minute": 1195757, "undone_new_orders": 3831, "errors": 0, "new_order": {"done": 402423, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "payment": {"done": 384189, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "order_status": {"done": 35860, "failed": 0, "p50_us": 256, "p99_us": 992}, "delivery": {"done": 35797, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "stock_level": {"done": 35652, "failed": 0, "p50_us": 288, "p99_us": 1024}, "server_threads": "3", "cpu_us_per_transaction": 43.3, "core_shares": {"pure-owner": 0.92, "pure-checkpoint": 0.01}, "resident_mib": 466.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 466.1, "pure_state_mib": 237.5, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26716, "burst_events": 818664, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-3-linux-aarch64.jsonl new file mode 100644 index 0000000..f4bc7e0 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-3-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43401, "new_orders_per_minute": 1161269, "undone_new_orders": 3714, "errors": 0, "new_order": {"done": 390809, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 373024, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "order_status": {"done": 34840, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 34749, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "stock_level": {"done": 34616, "failed": 0, "p50_us": 304, "p99_us": 1280}, "server_threads": "3", "cpu_us_per_transaction": 44.4, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 454.3, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 454.3, "pure_state_mib": 231.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26213, "burst_events": 794954, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-4-linux-aarch64.jsonl new file mode 100644 index 0000000..7d2d521 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-4-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44200, "new_orders_per_minute": 1182404, "undone_new_orders": 3789, "errors": 0, "new_order": {"done": 397924, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "payment": {"done": 379945, "failed": 0, "p50_us": 1408, "p99_us": 3328}, "order_status": {"done": 35457, "failed": 0, "p50_us": 248, "p99_us": 1088}, "delivery": {"done": 35437, "failed": 0, "p50_us": 1408, "p99_us": 3200}, "stock_level": {"done": 35245, "failed": 0, "p50_us": 272, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 43.0, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 461.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 461.9, "pure_state_mib": 235.1, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26618, "burst_events": 809602, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-5-linux-aarch64.jsonl new file mode 100644 index 0000000..9bc6157 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-5-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44277, "new_orders_per_minute": 1184600, "undone_new_orders": 3801, "errors": 0, "new_order": {"done": 398668, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 380671, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "order_status": {"done": 35491, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35426, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "stock_level": {"done": 35289, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 44.1, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 463.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 463.5, "pure_state_mib": 235.5, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26815, "burst_events": 811039, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-6-linux-aarch64.jsonl new file mode 100644 index 0000000..7ac5094 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-6-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.72, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43843, "new_orders_per_minute": 1172899, "undone_new_orders": 3755, "errors": 0, "new_order": {"done": 394728, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 376930, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "order_status": {"done": 35183, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35075, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "stock_level": {"done": 34959, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 43.7, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 458.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 458.0, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26180, "burst_events": 803062, "checkpoints": 39}} |