Apollo Client fetchMore Duplicates or Drops Pages: Diagnosing Cache Merge Failures
A diagnostic guide to Apollo Client pagination failures: why fetchMore duplicates or drops pages, how to inspect the normalized cache, and when to escalate.
ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
A diagnostic guide to Apollo Client pagination failures: why fetchMore duplicates or drops pages, how to inspect the normalized cache, and when to escalate.
Learn how Doctrine’s Paginator adds LIMIT/OFFSET and a distinct count query to load only the needed entities, reducing memory usage on large lists.
Phoenix OFFSET-LIMIT pagination becomes inefficient for large offsets due to linear scan overhead. Keyset pagination using WHERE clauses on indexed columns provides better performance for deep paging.
A decision guide for choosing between Lucid's built-in paginate() API and manual keyset pagination for list endpoints in AdonisJS v6 applications.
Learn how to handle DynamoDB's 1 MB result limit using LastEvaluatedKey and ExclusiveStartKey, and why empty item lists don't always mean the end of your data.
Learn how to implement efficient cursor‑based pagination with Prisma Client, including forward and backward pages, detecting next/prev cursors, and verifying the generated SQL.
Learn how to replace Sequelize's findAndCountAll OFFSET pagination with keyset (cursor‑based) pagination to keep query time constant on large tables.
Spring Data JPA's Pageable and Sort eliminate hand-written LIMIT/OFFSET and count queries. Here's how they work, a working example, and where the convenience breaks down.
DataGrip sometimes loads all rows of a large query, disabling pagination and causing freezes. This guide diagnoses the common causes, walks through ordered checks, applies fixes, and tells you when to contact JetBrains support.