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

Profile perf of SBE $lookup with deep paths in foreign

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Fully Compatible
    • QE 2022-04-18
    • 135

      The currently proposed implementation creates a set of foreign key values per foreign document and then intersects it with a similar set created from a local document. While this is conceptually correct, we should investigate whether we could avoid creating the foreign set and instead probe for each foreign key value against the local set.

      Because the set is per input document we are not too worried about the excessive memory usage, the main concern is CPU cycles. However, because the empty set of keys should be matched to null and it might require additional stages, probing can end up being as CPU-heavy as materializing the set.

            Assignee:
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Reporter:
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: