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.