Editorial question93.3K views648 votes0 answers4,945 following
AI-generatedHigh latency observed when using Mongoose skip/limit for deep page numbers
Goal: Determine why query response time grows noticeably when requesting higher page numbers while paginating a large collection with Mongoose’s skip() and limit() methods. Constraints: The collection contains millions of documents, the application must return results in a consistent order, and we cannot change the existing sort field without impacting other