Custom report slow performance in Clarity due to issue with SQL Queries

book

Article ID: 194701

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

  1. Some reports take over 10 minutes to run.
  2. The reports are all custom reports or customized standard reports. 

Examples:

  • Gantt Summary Report 
  • Project Summary Report 
  • Project Status Report
  • Project KPI Report 

Cause

This type of issue can occur with any poorly formed SQL queries

Environment

Release : All Supported Releases

Component : CA PPM SAAS JASPERSOFT

Resolution

For this issue, the report designer would need to be contacted to assist in redesign of the report queries. Some tips:

  1. Evaluate the security used in the queries of the Reports including changing "inner-joins" to different checks. 
  2. Try adding/removing conditions to help determine any improvements that can be made based on improvements noticed with conditions

Additional Information

See:194700 - Advanced Reporting: Known KBs related to slow performance