How to reduce Poor performance querying on process variables?
Issue
- Is DDL not include indexes on the
VariableInstanceLog table
injboss-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.