Deep Page Crawl
An endpoint runs ORDER BY created_at DESC LIMIT 20 OFFSET ?, with an index on created_at. At OFFSET 0 it answers in a few milliseconds; at OFFSET 200000 the same query takes well over a second. Why does cost grow with the offset?
Sign in to answer questions and track your progress
Sign In