Experiments & Performance Over Time

resqlite was built through rigorous, benchmark-driven experimentation. This page tracks every optimization attempt — accepted, in review, and rejected — alongside the performance data behind each decision. Use the headline charts for broad health, the scenario charts for app-shaped workloads, and click any data point to see the experiment and metrics that drove the decision.

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)

Reactive Scenarios — lower is better

App-shaped reactive workloads: feed updates, sync bursts, keyed subscriptions, and high-cardinality fan-out

Reactive Micros — lower is better

Invalidation latency, small-stream fan-out, churn, and unchanged-result suppression

Point Query Throughput — higher is better

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