When thousands of operations in the DBQueue have more than one parameter, performance of the DBQueue processing will be slow.
(Example: 'CPL-K-ComplianceSubRuleFillPersonS': param1=Object=UID_ComplianceRule; param2=SubObject=UID_Person)
This is a defect in the Main DBQueue agent job dispatcher (Procedure QBM_PDBQueueHelpMainFillSlot).
There is also no useful index on DialogDBQueue for column SubObject, and the procedure uses internal variables which are created by a SQL custom user type (QBM_YHelperQueueSlotFill). This user type also has no index for SubObject.
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center