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 STARTER PACK-CLARITY PPM

Issue/Introduction

The new Staffing page is very slow when we add Period Metrics

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

Component : Clarity MUX UI Usability

Resolution

This is defect DE62277, fixed in 16.0