Fix performance problem in SBE $group by with large objects/arrays with similar values

ExportXMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • 9.1.0-rc0, 9.1.0-rc1025
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      In SBE, hashValue only hashes the first 4 values of an object or array.  So if you have a lot of objects with boilerplate at the beginning (tenantId, customerId, etc) before the values differ, $group operations and set operations such as $addToSet become very slow.

      To fix this, make SBE hash all fields of an object or array.

            Assignee:
            Logan Karbiner
            Reporter:
            Logan Karbiner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: