Add optimization to execute $lookup on local shards when possible

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Aggregation Framework, Sharding
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      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.

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Mohannad Saeed
            Votes:
            2 Vote for this issue
            Watchers:
            14 Start watching this issue

              Created:
              Updated:
              Resolved: