Why DuckDB 2.0 is faster
DuckDB 2.0 alpha vs 1.5.5 on one laptop: recursive CTEs up to 90x, VARIANT 6x faster than JSON text, async I/O 2.4x on S3. What changes, and how to model data to get the speedup. | Reading time: 15 min read
Summary
DuckDB 2.0 introduces significant performance improvements over its predecessor, boasting up to 90 times faster recursive CTEs and major enhancements in handling data formats. The article details the specific changes and offers insights on data modeling techniques to maximize these speed gains.
Comments (70 of ) ⌛