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

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content