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

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Duplicate
    • 4.2.0
    • None
    • Performance
    • None
    • 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

              david.storch@mongodb.com David Storch
              edumanasses@gmail.com Eduardo Justi
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: