search cancel

View with Group By significantly slower in Staffing workspace with Per Period Metrics

book

Article ID: 237853

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Performance Issue. View with Group By significantly slower in Staffing workspace with Per Period Metrics enabled, returns in many minutes vs few seconds without Group By or without Per Period Metrics. 

Steps to Reproduce: 

  1. On a large dataset, with admin user
  2. Connect to Modern UX - Staffing workspace
  3. Create few views that return at least 50k or records, 100 per page
Basic View - contains only OOTB basic fields such as Resource name, Project Name etc.
Basic View with Group By on Resource Name
  1. Now add Per Period Metrics - Allocation , 12 months, with Grand Totals, test the timings
View with Per Period Metrics Allocation
View with Per Period Metrics Allocation and Group by Resource Name
  1. Now add Per Period Metrics - Remaining Availability, 12 months, with Grand Totals, test the timings
View with Per Period Metrics Allocation and Remaining Availability
View with Per Period Metrics Allocation and Remaining Availability and Group by Resource

Expected Results: Group by should not cause a very significant slowdown in performance. 

Actual Results: The Group By views return in multiple minutes vs few seconds without the Group By. 

Environment

Release : 16.0.1, 16.0.1.1, 16.0.2 

Resolution

This is DE64536 , targeted for fix in Clarity 16.0.2.1 and 16.0.3

Additional Information