[Spike] Investigate if replacing regex with string comparison improves filtering performance in change stream pipeline

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • QE 2024-11-11, QE 2024-11-25
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Given the current usage of regular expressions to match collection names in the aggregation pipeline, we should investigate whether switching to string or substring comparison might yield better performance. Regular expressions are known to be computationally intensive, especially when used repeatedly across multiple conditions.

        1. cs_stage_match.js
          6 kB
        2. plain_match.js
          3 kB

            Assignee:
            Sebastien Mendez
            Reporter:
            Lee Maguire
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: