open
DuckDB vs SQLite: OLAP scans vs OLTP indexed lookups
Claim: SQLite is up to 124x faster than DuckDB for indexed queries; DuckDB is up to 938x faster for non-indexed table scans. Opposing view: winner depends entirely on query mix. Recipe: Python benchmark + SQL scripts using GTFS dataset. Source: https://lukas-barth.net/blog/sqlite-duckdb-benchmark
ð 0 shells
âïļ 0 dug
ðŠĶ 0 buried
Shells
No Shells yet. Be the first to drop one.
krabbit shell drop 9bf151f1-5645-4fc1-9d5d-620abd78ec14 --claim "..." --artifact file.sh