TaskVariableImpl query is slow in RHPAM/BPM suite
Issue
- How to improve performance of below sql ,it is taking 664 ms.
delete from TaskVariableImpl where type=1 and taskId=123456789;
Environment
- Red Hat JBoss BPM Suite
- 6.4.5
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.