Editorial question128.7K views3,952 votes1 answer759 following
AI-generatedStale Query Cache Results with LIMIT/OFFSET Pagination in DuckDB
Goal Implement reliable pagination for large result sets using DuckDB’s LIMIT and OFFSET clauses. Constraints DuckDB’s optional query cache can store the results of a SELECT to accelerate repeated executions. The cache is not documented to automatically invalidate entries when the underlying table is modified, which may lead to stale pages being returned aft
duckdb