Performance Issue When Opening Project to Do Module

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A performance issue is observed when opening To Do items inside Project To Do module.

Environment

Clarity 16.3.3

Cause

When reviewing the trace captured, the issue seems to be only when the view displays To Do custom attributes. Standard View (with out-of-the-box attributes only) performs well. The query that gets data from the To Do custom attributes tables is taking time to complete.

Resolution

Using Oracle DB, stats pack helped confirm the performance issue in the DB side. The DBA tuned the slow queries (custom attribute related) identified in the app-trace.xml file.