SQLite vs DuckDB on the same $16 box: every cliff moved 100x · Traceway
- Same $16.49/month server, same Traceway binary, two embedded databases.
- DuckDB writes 4x to 15x faster than SQLite, serves dashboards at 100x the row count, and stores a billion metric points in 10.8 GB.
- TL;DR I spent six days working on and running a benchmark of observability data on DuckDB.
Unverified
- Same $16.49/month server, same Traceway binary, two embedded databases.
- DuckDB writes 4x to 15x faster than SQLite, serves dashboards at 100x the row count, and stores a billion metric points in 10.8 GB.
- TL;DR I spent six days working on and running a benchmark of observability data on DuckDB.
Sources: Tracewayapp