Staffing Page Per Period Metrics performance on large datasets

book

Article ID: 222319

calendar_today

Updated On:

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. 

Cause

DE62277  

Environment

Release : 15.9.3

Component : Clarity MUX UI Usability

Resolution

Fixed in Release 16.0.0