` Chunked Query Results in the DuckDB Java Driver ` ๐ฆโ
The DuckDB #
Java# driver can now return query results as a lazily fetched sequence of columnar data chunks, avoiding JDBCโs one-row-at-a-time ResultSet and its per-value overhead.
DuckDB is a columnar, vectorized database. Every operator inside the engine works on data chunks: batches of column vectors, 2,048 rows at a time. That is a big part of why #
DuckDB# is fast: the engine amortizes interpretation overhead over thousands of values instead of paying it once per value.
JDBC, on the other hand, was designed in 1997. Hereโs how the new DuckDB Java driver bridges the two: