reorder $limit before $lookup in pipeline

XMLWordPrintableJSON

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

      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.

              Assignee:
              Katherine Wu (Inactive)
              Reporter:
              Asya Kamsky
              Votes:
              1 Vote for this issue
              Watchers:
              14 Start watching this issue

                Created:
                Updated:
                Resolved: