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

Add optimization to execute $lookup on local shards when possible

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Major - P3
    • Resolution: Duplicate
    • None
    • None
    • Aggregation Framework, Sharding
    • None

    Description

      Performing joins using local shard indices is cheap. In this setup, parent-child relationships can be implemented as long parent and child documents live on the same shard through proper routing by application developers. This feature is similar to ElasticSearch has_parent and has_child queries. $joinOne works with a single object while $joinMany works with an array of objects.

      Attachments

        Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-29159 Allow "from" collection of $lookup to be sharded

          • Major - P3 - Major loss of function.
          • Closed
          has to be done after

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-29159 Allow "from" collection of $lookup to be sharded

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-22384 Add $lookUpOne to retrieve single Object on result

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-27496 allow self-$lookup on shard key value equality pre-merge on a sharded collection

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

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              geekox86 Mohannad Saeed
              Votes:
              2 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: