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

$skip and $limit should be moved before $project

    XMLWordPrintable

Details

    • Fully Compatible
    • ALL

    Description

      While this is performance-neutral on its own, it enables other optimizations such as combining sort and limit. This should probably be done right before Optimizations::Local::moveLimitBeforeSkip.

      Attachments

        Issue Links

          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-19152 Reorder $project to be after limits and skips

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-4506 aggregation: optimize by pushing matches to earlier in a pipeline

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

          Activity

            People

              james.cohan James Cohan
              mathias@mongodb.com Mathias Stearn
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: