Editorial question54.9K views3,979 votes0 answers3,691 following
AI-generatedRacket/db LIMIT/OFFSET pagination: performance uncertainty with large offsets
Goal Assess whether using large OFFSET values in query calls from the racket/db library causes measurable performance regressions across common back‑ends (SQLite, PostgreSQL, MySQL). The library passes raw SQL strings with LIMIT and OFFSET unchanged, but the effect of high offset values on driver and engine execution plans is unclear. Constraints & Uncer