Question

3
Replies
518
Views
Debojyoti Mukherjee Member since 2014 6 posts
Areteans Technology Solutions
Posted: 3 years ago
Last activity: 3 years 8 months ago
Closed

Poor performance due to multiple time DB hits (pc_assign_worklist & pc_assign_workbasket).

I have a requirement where I need to show list of cases for a particular user/caseowner. Now each case can have multiple assignments, where all the assignment owners should be same as the case owner. For this I am taking up each case and searching pc_assign_worklist & pc_assign_workbasket for assignments; then I am comparing all the pxAssignedOperatorID with caseowner. But if have 1000 cases in the list, I am hitting the two DBs 1000*2=2000 times. This is causing the final list to be populated after 10-15 minutes.

How to resolve this issue? Thanks in advance.

Data Integration Java and Activities Data Integration System Administration Reporting
Moderation Team has archived post
Share this page LinkedIn