-
Enhancement
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
False
-
NEW
-
NEW
-
Undefined
-
---
-
---
-
-
2020 Week 52-03 (from Dec 21)
We've got a request from a customer to add 3 new indexes to rhpam that could significantly improve the performance.
The following is quoted from the customer:
"From QA they recommended us to create 3 new indexes to the database model, which has reduced response times by 83%. Specifically, we went from 1180 ms to 193 ms."
Here are the indexes:
create index IDX_NodeInstanceLog_workItemId ON NodeInstanceLog(workItemId);
create index IDX_TaskEvent_taskId ON TaskEvent(taskId);
this on is created is already IDX_PInstLog_pInsteDescr
create index IDX_ProcessInstanceLog_processInstanceDescription ON ProcessInstanceLog(processInstanceDescription);
Can we add them to our rhpam product?