Performance issues when multiple PWO objects exist in the database
说明
The SQL query PWODecisionRuleRulerDetect takes a long time to run when multiple PWO records exist. The more PWO records that exist, the longer this query takes to run.
原因
This issue is caused because the WhereClause does not contain a restriction to UID_PersonWantsOrg, so the query has to handle more and more records as the number of PWOs increases.
Defect ID 25670.
解决办法
WORKAROUND
None.
STATUS
Please contact Support for a hotfix. Product defect 25670. The issue is resolved in versions 7.0.3 and 7.1.1.