|
|
|
|
|
|
by 1egg0myegg0
753 days ago
|
|
|
Howdy! Thanks for your benchmarking! Your blog does a great job contrasting the two use cases. I don't think too much has changed on your main use case, however here are a few ideas to test out! DuckDB can read SQLite files now! So if you like DuckDB syntax or query optimization, but want to use the SQLite format / indexes, that may work well. Since DuckDB is columnar (and compressed), it frequently needs to read a big chunk of rows (~100K) just to get 1 row out and decompressed. Mind trying to store your data uncompressed? Might help in your case! (PRAGMA force_compression='uncompressed') Links:
https://duckdb.org/docs/extensions/sqlite |
|
|