Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4025

[GSS] (6.3.z) BPM Suite 6 - Database Queries Performing Poorly (Adding INDEXES)

    Details

    • Type: Bug
    • Status: Verified (View Workflow)
    • Priority: Minor
    • Resolution: Done
    • Affects Version/s: 6.3.0, 6.1.0.GA
    • Fix Version/s: 6.3.2
    • Component/s: Business Central, Installer
    • Labels:
      None
    • Environment:

      Red Hat BPM Suite 6.x DDLs - Supplementary Tools

    • Target Release:
    • Fix Build:
      CR2
    • Workaround Description:
      Hide

      The workaround is to create the indexes for those audit tables while it is not available in DDLs.

      Show
      The workaround is to create the indexes for those audit tables while it is not available in DDLs.

      Description

      Some BPM Suite 6 database queries were performing poorly (slowness) and it has been improved after adding some indexes for NodeInstanceLog and VariableInstanceLog. For instance:

      VariableInstanceLog ADD INDEX (variableId, processInstanceId);
      VariableInstanceLog ADD INDEX (variableId, value);

      And:

      NodeInstanceLog(processInstanceId,nodeType);

      The DDL scripts only create indexes for ProcessInstanceLog table. It is needed to include those indexes for the other audit tables.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  marco.rietveld Marco Rietveld
                  Reporter:
                  asamara Amana Juricic
                  Tester:
                  Marek Winkler
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: