Staffing - Allocation by Investment causes database bottleneck and slow performance

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Slowness on Staffing Allocation by Investment tab as users go into Clarity. This issue was noticed on Oracle but may also affect other vendors

Many thousand users using Staffing, which has many thousands of rows of data. The view returns the entire data. We have set up the Recommended view but not everyone is using it. It may take about 1-2 min. to return the results for no filter, and many users doing it at once increases the database load

Steps to Reproduce:

1. Connect to Modern UX - Staffing - open Staffing Allocation by Investment without additional filtering

Expected Results: The Staffing page to open within a reasonable amount of time

Actual Results: The Staffing page is spinning and does not display final results for a significant amount of time. On the database the query continues to run.

The application causes bottlenecks on the database, which can be seen by DBA as recurrent connections with the Staffing queries, that keep opening for each next 500 rows. Killing them and restarting may alleviate the problem temporarily 

 

Environment

Release : 16.1.3

Resolution

Resolved in 16.2.0 and 16.1.3.2. This was originally tracked as DE77918

The fix includes a pre-filter, which will also benefit other database vendors (PostgreSQL and MSSQL)