Tag
DuckDB's file_row_number option for paging through Parquet files is 2.53x faster than using LIMIT/OFFSET, as it leverages row group metadata to skip irrelevant blocks, but the benefit depends on having many row groups.