Performance Considerations

The performance of each report depends on the number of rows each report retrieves, the amount of logic each report processes, and the number of graphical and tabular components on the report.

To improve the performance of a report:

1. Limit the number of rows each report retrieves.

2. Look at the number of event rules for each grid row that are being fetched on the One View Report applications.

3. Look at the graphical and tabular components in the report. Sometimes a pivot table with a large number of columns may take a long time to render. In this case, reduce the number of columns in the pivot table.

In general, it is a good idea to reduce the number of fields selected in the data model. This will speed up the report generation and rendering.

One View Reporting is an interactive solution that is not designed to retrieve tens of thousands of database records. If you need to work with a large amount of data, using either the Read Only JDBC driver or a UBE report will provide better performance.