OFFSET Pagination Works. Until It Doesn’t.

Why OFFSET pagination slows down at scale and breaks data consistency