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
Release : 16.1.3
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)