Experiments & Performance Over Time

resqlite was built through rigorous, benchmark-driven experimentation. This page tracks every optimization attempt — accepted and rejected — alongside the performance data from 50 benchmark runs. Select a chart category on the left and click any data point to see the related experiment on the right.

Read Performance — lower is better

select() maps, selectBytes() JSON, and schema wide — 1K rows, wall time (ms)

Write Performance — lower is better

Single inserts (100 sequential) and batch inserts (1K rows), wall time (ms)

Transactions — lower is better

Interactive transaction and transaction reads/writes, wall time (ms)

Concurrency & Parameterized — lower is better

4x concurrent reads and 100-query parameterized workload, wall time (ms)

Streaming — lower is better

Invalidation latency, fan-out, and stream churn, wall time (ms)

Point Query Throughput — higher is better

Single-row lookups per second, measuring dispatch latency floor
Loading…
Loading experiments...