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

Details

    • Bug
    • Resolution: Done
    • 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.

    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.

      Attachments

        Issue Links

          clones

          Bug - A problem that impairs or prevents the functions of the product. RHBPMS-4024 BPM Suite 6 - Database Queries Performing Poorly (Adding INDEXES)

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified
          relates to

          Bug - A problem that impairs or prevents the functions of the product. JBPM-5186 Database Queries perform poorly on VariableInstanceLog and NodeInstanceLog

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved: