Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-1967

Optimize Execution Tree (pre)fetching

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.1.0, 7.1.0-alpha4
    • Component/s: engine
    • Labels:
      None

      Description

      AT:

      • I can enable execution tree prefetching in ProcessEngineConfiguration
      • Implement Execution Tree prefetching:

      Fetch all the executions inside the same process instance as list and then reconstruct the complete execution tree.

      In many cases this is an optimization over fetching the execution tree lazily. Usually we need all executions anyway and it is preferable to fetch more data in a single query (maybe even too much data) then to run multiple queries, each returning a fraction of the data.

      The most important consideration here is network roundtrip: If the process engine and database run on separate hosts, network roundtrip has to be added to each query. Economizing on the number of queries economizes on network roundtrip. The tradeoff here is network roundtrip vs. throughput: multiple roundtrips carrying small chucks of data vs. a single roundtrip carrying more data.

        Attachments

          Activity

            People

            Assignee:
            smirnov Roman Smirnov
            Reporter:
            meyer Daniel Meyer
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: