Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-9545

add indexes to rhpam to improve the performance

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 7.49.0.Final
    • None
    • Runtime Engine
    • None
    • False
    • False
    • NEW
    • NEW
    • Undefined
    • ---
    • ---
    • 2020 Week 52-03 (from Dec 21)

      We've got a request from a customer to add 3 new indexes to rhpam that could significantly improve the performance. 

      The following is quoted from the customer:

      "From QA they recommended us to create 3 new indexes to the database model, which has reduced response times by 83%. Specifically, we went from 1180 ms to 193 ms."

      Here are the indexes:

      create index IDX_NodeInstanceLog_workItemId ON NodeInstanceLog(workItemId);
      create index IDX_TaskEvent_taskId ON TaskEvent(taskId);

      this on is created is already IDX_PInstLog_pInsteDescr
      create index IDX_ProcessInstanceLog_processInstanceDescription ON ProcessInstanceLog(processInstanceDescription);

       

      Can we add them to our rhpam product?

              elguardian@gmail.com Enrique González Martínez (Inactive)
              rhn-support-ghu Gary Hu
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: