Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-43297

Inefficient query on view due to $limit and $skip stages not being pushed down

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: 4.2.0
    • Fix Version/s: None
    • Component/s: Performance
    • Labels:
      None
    • Sprint:
      Query 2019-10-21

      Description

      I've noticed that views are examining all documents matching query regardless of the value provided to the cursor's skip or limit. The query is quite simple and the aggregated data from the view is also very simple. But since the view is examining all documents that match that specific query we are unable to use the view with that pipeline due to how long it takes to complete the query. 

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: