Slow performance on the Create Timesheet page when adding multiple assignments. The query that is causing the bottleneck includes a summation of the pending actuals.
Steps to Reproduce:
Expected Results: There should not be any performance issue in loading the page.
Actual Results: The more the number of users, the page loading slows and eventually ends up in an outage.
The below query gets invoked when accessing the timesheet page which was causing the bottleneck
SELECT A.PRID, SUM(PENDTE.PRACTSUM) AS ACTUALS
FROM PRASSIGNMENT A, PRTIMEENTRY PENDTE, PRTIMESHEET TS+
WHERE A.PRID IN (SELECT PRASSIGNMENTID
AND PRASSIGNMENTID IS NOT NULL)
AND PENDTE.PRASSIGNMENTID = A.PRID
AND PENDTE.PRTIMESHEETID = TS.PRIDAND PENDTE.PRACTSUM > 0
AND TS.PRSTATUS < 4
GROUP BY A.PRID
Component: Clarity Timesheets