Refactor PrepareExecutionHelper for faster cached plan execution

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Won't Do
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • QO 2024-04-15, QO 2024-04-29
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      PrepareExecutionHelper appears to be intended to be a lightweight wrapper for a bunch of common execution helper functions. As it's implemented, however, it's actually very expensive – for example, its construction and destruction is explicitly expensive in a way that doesn't seem to be necessary, the way that the cached plan and its debugging information are being propagated are also incurring creation and destruction overhead.

      Refactoring this class to be less expensive could gain up to ~1.9% runtime performance in getExecutorFind() for classic index scans.

              Assignee:
              William Qian (Inactive)
              Reporter:
              William Qian (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: