Custom portlet based on dynamic NSQL is performing slow. It takes approximately 9 minutes.
Release : 15.9.2
One or more of the following has been progressively performed
Can the NSQL be further improved/optimized/rewritten? Run the extracted query directly against the database and gauge its performance. Is it poor or acceptable performance? If poor, this is an issue with the query. The exact query that is executing against the DB can be obtained by a trace.
Run explain analyze SQL or have DBA team run it. The NSQL will need to be tuned/rewritten based on the output.