Task Board page performance issue for investments having huge assigned resources

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Other Work equivalent CITs having all resources in the system assigned to a single investment causes performance issue in the Task Grid and Board tab

Environment

Release : 16.1.1

Cause

STEPS TO REPRODUCE
1. Login to a relatively large dataset machine (issue replicated with >10k users)
2. Create a CIT 
3. Navigate to the CIT in MUX and assign all the 10K resources(or something similar) to this CIT. 
   Note: This CIT is a substitute of Other Works in Classic UX like Leave, Training etc where all resources in the system will be assigned to this Investment.
4. Identify a resource and assign the resource to few other Investment tasks as well. 
5. Navigate to Task Grid page with only the default filter. 
   Expected and Actual: The page loads 35k tasks in 1-2 seconds. 
6. Apply the filter Assigned Resource = Current User (it can be any resource and not just current user)
   Result: The page takes 12+ seconds to load 17 tasks
7. Remove the Assigned Resource filter and click on Board tab
   Result: The page loads quickly
8. Under View Options, configure card and add Assigned Resource to the card
9. Apply the filter Assigned Resource = Current User in the Board tab 

Expected: The board page loads quickly without much delay
Actual: The page takes almost a minute or at times just freezes and never comes back.

Workaround: 
1. Either remove the Assigned Resource from the cards
2. Or apply the filter Type (Common Investment) is not equal to CIT having all the resource assignments. 

Resolution

DE69140 - Fixed in 16.1.2