Generating reports is slow and causes timeouts

You might encounter slow performance or transaction time-outs during report generation for certain reports against large data sets.

To improve performance and reduce time-outs, follow these best practices:
  • When you run the large reports in PDF output format, specify the appropriate filters or parameters and avoid the usage of the default filter 'Any' that fetches all the records.
  • In a large data deployment, specify the HTML output format. HTML format supports the pagination, which renders one page at a time and provides the options to move to the next pages.
  • Tune the database. See the IBM Verify Identity Governance Performance Tuning Guide at http://www-01.ibm.com/support/docview.wss?uid=swg27036205 for suggested indexes to set on columns in Report DB tables.