NSQL Portlet Query Running Slow
search cancel

NSQL Portlet Query Running Slow

book

Article ID: 221065

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Custom portlet based on dynamic NSQL is performing slow. It takes approximately 9 minutes.

Environment

Release : 15.9.2

Resolution

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.
Powered by Wolken Software