Summary: For a large dataset, the Timesheet grid page never loads when Totals column is included in the results. This causes the CPU at the DB to eventually hit 100% if they are not killed on time. The potential performance issue lies with the view - tim_timesheet_act_sum_v.
Steps to Reproduce:
1. Login to a 16.0.1 Clarity environment which has a large dataset (>300k timesheets)
2. Navigate to MUX --> Timesheet tab
3. Add the below columns to the List view
Time Period Start Date
4. Use the below filters
Active = yes
Timesheet status = Open,Submitted and Returned
OBS = Use a Resources OBS
Timeperiod = current period
Actual & Expected: 118 timesheet records are populated in the grid page pretty quickly
5. Add Totals Column to the Grid page and use the same filters as above
Expected Results: Timesheet records are populated in the grid page pretty quickly.
Actual Results: The page never loads.
Workaround: Remove the Totals column.
DE64943 , resolved in 16.0.2