TinyJoin
v0.5.0 benchmarks
Fastest in 10 of 20 workloads.
Never the slowest.
Against SQLite 3.53.4 and PGlite 0.5.8, each in a browser Worker on OPFS.
Download, gzip1.3× smaller than SQLite
- TinyJoin
- 339 KiB
- SQLite
- 457 KiB
- PGlite
- 5.6 MiB
First open1.7× faster than SQLite
- TinyJoin
- 51.7 ms
- SQLite
- 85.8 ms
- PGlite
- 1.12 s
Read 10,000 rows7.0× faster than SQLite
- TinyJoin
- 6.40 ms
- SQLite
- 44.8 ms
- PGlite
- 45.9 ms
Also fastest at
- Reopen 1.7×
- GROUP BY 1.4×
- LIKE scans 1.2×
- Index builds 1.2×
- Joins 1.1×
- Autocommit inserts 1.1×