Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Reviewed
-
4.2, 4.3
-
Active subscription
Description
Default behaviour of approvers has useless performance, can't be used at all. Even if there are no approvers, no workflows it slows down midpoint to the point it's not usable (20 times slower).
First cause is DB query, that causes a lot of disk IO reads:
SELECT o.oid, o.fullobject FROM m_focus o INNER JOIN m_object o ON o.oid = o.oid LEFT OUTER JOIN m_reference r ON o.oid = r.owner_oid AND (r.reference_type = 8) WHERE r.targetoid = :1 AND (r.relation IN (:2, :3));
Only way to get midpoint working was to disable default approval behavior in system config using:
<workflowConfiguration>
<useLegacyApproversSpecification>never</useLegacyApproversSpecification>
<useDefaultApprovalPolicyRules>never</useDefaultApprovalPolicyRules>
</workflowConfiguration>