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)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 6.3.2
    • 6.3.0, 6.1.0.GA
    • Business Central, Installer
    • None

    • Red Hat BPM Suite 6.x DDLs - Supplementary Tools

    • CR2
    • 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.

      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.

              marco.rietveld Marco Rietveld (Inactive)
              rhn-support-ajuricic Amana Juricic
              Marek Winkler Marek Winkler (Inactive)
              Marek Winkler Marek Winkler (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: