High CPU caused with the query "select correlatio0_.processInstanceId as col_0_0_ from CorrelationKeyInfo correlatio0_ where correlatio0_.name=:1"
Issue
-
The following query causes high CPU during load testing:
select correlatio0_.processInstanceId as col_0_0_ from CorrelationKeyInfo correlatio0_ where correlatio0_.name=:1
-
What is the use of this query in the engine?
- Why does this query uses so much CPUs when "name" column of the CorrelationKeyInfo table is equal to null in 90% of cases;
- Is there a way to disable this query?
Environment
- Red Hat Process Automation Manager (RHPAM) 7.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.