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

Profile perf of SBE $lookup with deep paths in foreign

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.0.0-rc0
    • None
    • None
    • Fully Compatible
    • QE 2022-04-18
    • 135

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: