Staffing Page Per Period Metrics performance on large datasets

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Performance Issue. The new Staffing Workspace page is very slow when you are using a large dataset with over 450k records. The initial loading is slow. Adding Actuals in the Per-Period Metrics for 12 periods also causes it to slow down. 

Steps to Reproduce:    

1. Connect to a very large dataset (Modern UX) with over 450k records in Staffing page
2. Go to Staffing page
3. Note it takes over 30-40 sec to get all records to return
4. Make sure there is no grouping and filter
5. Now add a Per Period Metrics - 12 months - Grand Totals - Allocation
6. Note the timing
7. Filter to get around 5k results
8. Now add Actuals - note the timing

Expected Results: The page to respond and return results within reasonable time (10 sec max) as it should return 100 records at a time. 

Actual Results: The page is very slow, takes over 20 sec for most requests. 

Environment

Release : 15.9.3

Resolution

This is DE62277, fixed in 16.0.0