|
|
|
|
|
|
by ryanworl
1366 days ago
|
|
|
Storage layout is not the primary issue here because IO throughput on commodity hardware has increased significantly in the last 10 years. DuckDB is significantly faster than SQLite because it has a vectorized execution engine which is more CPU efficient and uses algorithms which are better suited for analytical queries. If you implemented a scan operator for DuckDB to read SQLite files, it would still have better performance. |
|
|
And yes it is fast!
https://github.com/duckdblabs/sqlite_scanner