How to reduce Poor performance querying on process variables?
Issue
- Is DDL not include indexes on the
VariableInstanceLog tableinjboss-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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
