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

Missing index on ACT_RU_TASK.PARENT_TASK_ID_

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Won't Fix
    • Icon: L3 - Default L3 - Default
    • None
    • 7.6.5
    • optimize
    • Virtual Machine with Ubuntu 64bit, 16GB RAM, Intel Core 2x 2,4GHz

      As I said on the forum, I think there is a missing index on ACT_RU_TASK.PARENT_TASK_ID_. I've performed some stress tests with Oracle DB.

      1) Without the index
      a) Running and completing 10k process / empty DB / no process running in the background / 300-1000ms delay between each request - avg response time 95ms
      then
      b) Only running 500k process / no delay between requests - avg response time 1259ms
      then
      c) Running and completing 10k process / 500k process running in the background / 300-1000ms delay between each request - avg response time 8000ms

      2) With index created
      Exactly the same tests, times are better:
      a) avg response time 84ms
      b) avg response time 1248ms
      c) avg response time 104ms

      Also CPU Consumption is smaller.

      Cheers.

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              dikey94 Damian Kulig
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: