MUX Project Grid Performance

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce: 

Pre-requisite to reproduce this issue is to have around 6-10 million records in table  odf_locked_attributes 

1. Login to Clarity mux with project manager role 
2. Observe it takes around 10-60 seconds on the system which has around 6-10 million records in table  odf_locked_attributes 

Expected Results: Navigation to project grid on mux should be reasonably fast

Actual Results: Navigation to project grid on mux is slow and while reviewing it was seen most of the time is spend reading query on odf_locked_attributes 

Environment

Clarity 16.x

Cause

DE94850

Resolution

• Marginal optimization is done while reading of table odf_locked_attribute via DE94850 in 16.2.3 and backported to 16.2.2 patch 1 
• Further optimization pertaining to reading of table odf_locked_attribute is fixed in 16.2.3  (Targeted to release August 2024)