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

reorder $limit before $lookup in pipeline

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • Query 2019-12-16, Query 2019-12-30

    Description

      In pipeline: 

      [ ... {$lookup:{}}, {$addFields:{}}, {$lookup:{}}, {$limit:10}, ... ]

      moving $limit before the first $lookup stage will significantly reduce the amount of work that lookup and addFields have to do. We currently don't reorder $limit with $lookup, it appears.

      Attachments

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-27829 Reduce performance impact of DocumentSourceCursor batching

          • Major - P3 - Major loss of function.
          • Backlog
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-26442 Push $sort before $project and $addFields

          • Major - P3 - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-43297 Inefficient query on view due to $limit and $skip stages not being pushed down

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              katherine.wu@mongodb.com Katherine Wu (Inactive)
              asya.kamsky@mongodb.com Asya Kamsky
              Votes:
              1 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: