What range of doc scanned to doc returned ratio will be scalable?

Working with Data
, , ,
1 
          "executionStats": {
            "executionSuccess": true,
            "nReturned": 16,
            "executionTimeMillis": 552,
            "totalKeysExamined": 12114,
            "totalDocsExamined": 2045,

Here is an example of a query run.

totalKeysExamined /  nReturned = 757
totalDocsExamined / nReturned = 128

My Database has a collection with 100K documents totalling 300MB and 3 compound indexes totalling 200mb.

Are these numbers scalable?
If this query represents the most intensive and common query of my APP, how far can it scale?

2

Are you sure you aren’t wasting more time asking the same question again and again and again…than you would dedicating a few days to make a good analysis of the situation yourself, and finally asking a single, detailed, and useful question?

Just a suggestion.

1 Like