search cancel

Performance issue with Project Tasks in Classic UX

book

Article ID: 252897

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Project - Task page in Classic UX facing performance issue where it takes more than a minute to open a task and for Non admin users, its timing out.



Environment

Release : 16.0.3

Cause

STEPS TO REPRODUCE
1. Login to a 16.0.3 machine which has a considerable amount of tasks. 
2. Navigate to Projects and open any Project
3. Navigate to Task page and open any Task/Milestone with.without assignments in it.

Expected: The Task page opens in a couple of seconds
Actual: The Task page takes around 1 minute to load and for Non admin users its even timing out

Additional Info: 
The issue is consistent when the load on system creating Tasks/assignments is high. 

Resolution

The poor performance was due to the bloating on the task tables. PRASSIGNMENT and PRTASK were not included in the pg repack because they dont have a primary key + unique constraints so had to perform a full vacuum after taking down the services.