TaskVariableImpl query is slow in RHPAM/BPM suite

Solution Unverified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In