How to reduce Poor performance querying on process variables?

Solution Verified - Updated -

Issue

  • Is DDL not include indexes on the VariableInstanceLog table in jboss-brms-bpmsuite-6.3-supplementary-tools?
  • DB monitor tool reported that the following query is slow
select variablein0_.variableId as col_0_0_, variablein0_.variableInstanceId as col_1_0_, variablein0_.oldValue as col_2_0_, variablein0_.value as col_3_0_, variablein0_.externalId as col_4_0_, variablein0_.processInstanceId as col_5_0_, variablein0_.log_date as col_6_0_ from VariableInstanceLog variablein0_ where variablein0_.processInstanceId=:1 and (variablein0_.id in (select max(variablein1_.id) from VariableInstanceLog variablein1_ where variablein1_.processInstanceId=:2 group by variablein1_.variableId)) order by variablein0_.id

Environment

  • Red Hat JBoss BRMS (BRMS)
    • 6.3

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In