SQLite
Open SQLite in the Results Explorer
SQLite on BenchBox: 35 published runs across 10 benchmarks. Latest run 2026-10-28.
Benchmarks
- AMPLab, 3 runs
- ClickBench, 2 runs
- CoffeeShop, 6 runs
- H2ODB, 3 runs
- JoinOrder, 1 run
- Read Primitives, 4 runs
- SSB, 3 runs
- TPC-DS, 1 run
- TPC-H, 6 runs
- TPC-H Skew, 6 runs
Score definitions
- Power score
- Power@Size: scale factor × 3600 divided by the geometric mean of the query times of the final iteration, in seconds. Unit: queries per hour at scale factor size; higher is better. Definition in the benchmark methodology.
- Geomean query time
- Geometric mean of the displayed per-query times of the run. Unit: milliseconds, shown as seconds from 1,000 ms; lower is better. Definition in the benchmark methodology.
Ranked runs
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| AMPLab | SF 0.01 | power | v3.53.1 | 2026-08-26 | — | 0.8 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| AMPLab | SF 0.1 | power | v3.53.1 | 2026-08-26 | — | 9.1 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| AMPLab | SF 1 | power | v3.53.1 | 2026-08-26 | — | 115 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 1 | power | v3.53.1 | 2026-10-26 | — | 207 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| CoffeeShop | SF 0.01 | power | v3.53.1 | 2026-10-26 | — | 38 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| CoffeeShop | SF 0.1 | power | v3.53.1 | 2026-10-26 | — | 470 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | v3.53.1 | 2026-10-26 | — | 5.2 s | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| H2ODB | SF 0.1 | power | v3.53.1 | 2026-08-26 | — | 259 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 1 | power | v3.53.1 | 2026-08-26 | — | 3.06 s | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| JoinOrder | SF 1 | power | v3.53.1 | 2026-08-26 | — | 131 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | v3.53.1 | 2026-08-25 | — | 203 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 0.01 | power | v3.53.1 | 2026-08-25 | — | 16 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 1 | power | v3.53.1 | 2026-08-26 | — | 3.29 s | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | v3.53.1 | 2026-10-26 | 2,870 | 13 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v3.53.1 | 2026-10-26 | 5,464 | 63 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | v3.53.1 | 2026-10-26 | — | 37 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.01 | power | v3.53.1 | 2026-10-26 | — | 2.2 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | v3.53.1 | 2026-10-26 | — | 494 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
Runs not included in rankings
17 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (12); One or more queries failed. (3); Non-standard runs are unofficial and are not ranked. (2)
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| ClickBench | SF 1 | power | v3.53.1 | 2026-08-24 | — | 192 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 0.1 | power | v3.53.1 | 2026-08-26 | — | 433 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 0.01 | power | v3.53.1 | 2026-08-26 | — | 39 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | v3.53.1 | 2026-08-26 | — | 4.52 s | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 0.01 | power | v3.53.1 | 2026-08-24 | — | 8.1 ms | One or more queries failed. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | v3.53.1 | 2026-10-28 | — | 1.3 ms | One or more queries failed. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | v3.53.1 | 2026-10-28 | — | 18 ms | One or more queries failed. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | v3.53.1 | 2026-08-26 | — | 17 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | v3.53.1 | 2026-08-26 | — | 1.6 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | v3.53.1 | 2026-08-24 | — | 8.69 s | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v3.53.1 | 2026-08-26 | 7,059 | 52 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | v3.53.1 | 2026-08-25 | 3,820 | 9.4 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v3.53.1 | 2026-10-26 | — | 547 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v3.53.1 | 2026-08-25 | 7,238 | 494 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.01 | power | v3.53.1 | 2026-08-26 | — | 2.3 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | v3.53.1 | 2026-08-26 | — | 55 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | v3.53.1 | 2026-08-26 | — | 437 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |