[ BENCHMARKS ] measured results
source-linked numbers.
Each result set links to its source. The landing page shares the same data, so summary and detail stay aligned.
2.35x
TSBS geomean vs reference
3.57x
master suite overall geomean
3.16x
DBB total query speedup
3.08x
DBB per-query geomean
[TSBS] --- result set
TSBS mean query time
Mean query time on the same time-series workload. Lower is better; l normalized to 1.00x.
[MASTER] --- result set
master-benchmark cross-runtime suite
A 125-op comparable subset of the 135-op cross-runtime suite, grouped by primitive family and reported as section geomeans.
[DBB] --- result set
db-benchmark 50 GB groupby
The L solution for the db-benchmark groupby task against DuckDB on a 1e9-row CSV, with row counts and checksums validated.
load: l CSV read + partitioned store
73.5 s
load: DuckDB CSV into memory
27.1 s
total query time
l 56.6 s vs DuckDB 178.8 s
total query speedup
3.16x
per-query geomean
3.08x
validation
all 10 queries validated
| q | query | l -s | l s | DuckDB s | DuckDB/l |
|---|---|---|---|---|---|
| q1 | sum v1 by id1 | 0 | 0.103 | 0.262 | 2.54x |
| q2 | sum v1 by id1,id2 | 48 | 0.495 | 0.505 | 1.02x |
| q3 | sum v1, mean v3 by id3 | 16 | 1.599 | 34.045 | 21.29x |
| q4 | mean v1,v2,v3 by id4 | 0 | 0.128 | 0.153 | 1.20x |
| q5 | sum v1,v2,v3 by id6 | 16 | 3.804 | 26.060 | 6.85x |
| q6 | median v3, sd v3 by id4,id5 | 16 | 1.679 | 3.941 | 2.35x |
| q7 | max v1 - min v2 by id3 | 16 | 1.392 | 15.337 | 11.02x |
| q8 | top-2 v3 by id6 | 16 | 8.628 | 24.715 | 2.86x |
| q9 | corr(v1,v2)^2 by id2,id4 | 48 | 0.542 | 0.651 | 1.20x |
| q10 | sum v3, count by id1..id6 | 16 | 38.270 | 73.165 | 1.91x |