CouchBase record fetch

Couchbase Server
2

By default Index Scan timeout is 2min to avoid keeping indexer snapsot longtime which can impact cluster performance.

10 M records fetch takes time.
You can use different techniques.

  1. Use different queries and Pagination. May be keyset pagination https://blog.couchbase.com/offset-keyset-pagination-n1ql-query-couchbase/
  2. Use document keys through the N1QL and get the actual documents through SDKs.
  3. Increase Indexer timeout Index scan timed out