Intermittently, the results of a custom portlet is taking time to return data.
Example, it takes 4+ minutes to return data.
Release : 16.0.2
Component : Clarity Process Management
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.