Custom Portlet Performance

Products

• Clarity PPM SaaS

Issue/Introduction

Intermittently, the results of a custom portlet is taking time to return data.

Example, it takes 4+ minutes to return data.

 

Environment

Release : 16.0.2

Component : Clarity Process Management

Resolution

In one case study, the SQL behind the portlet was obtained and confirmed with action tracing. 

The SQL was then ran directly against the database and took same amount of time, which shows better database execution plan needs to be taken.

The SQL behind the portlet would need to be rewritten/refactored for optimization.