Monday, August 5, 2024
1 change · saas-17.4
Enhancements to existing features
The Timesheets and Planning analysis report now avoids repeating the same heavy calculation multiple times. This should make the report load faster, especially for larger datasets, improving day-to-day reporting efficiency.
Original PR description
Before this commit, the subquery provided in _number_of_days_without_weekend() was executed multiple times in _select(), which was decreasing the performance by a lot. After this commit, we build a CTE to ensure that we only execute this subquery once and use its result every time it's needed. task-3902302