NSQL Portlet Query Running Slow
search cancel

NSQL Portlet Query Running Slow


Article ID: 221065


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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

  1. 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.
  2. Run explain analyze SQL or have DBA team run it. The NSQL will need to be tuned/rewritten based on the output.