Oracle Reports : Performance Improvement tips
- In particular, setting the size of repeating frames and their contents to fixed, improves performance.
- Fixed graphical objects require more processing overhead as their contents have to be scaled to fit. Variable objects grow or shrink with the contents eliminating the need for scaling.
- Use the SUBSTR function in the report query to truncate the data at the database level, instead of truncating a character string from a field in the Report Builder layout.
For paper layout only reports, .rdf and .rep files run faster than a.jsp file
- Keep in mind that the larger and more complex a query gets, the more difficult it is to be maintained. Then we have to decide when to achieve the balance between performance and maintenance requirements.
- Format triggers can be used against repeating frames to filter data. However, by introducing filtering at appropriate levels, not only improve a report's performance but also reduce the complexity
Use the following filtering order whenever possible:
- Modify the SQL statement to prevent the data being returned from the server.
- Use the group filter to introduce filtering in the Data Model.
- Use return false inside the format trigger.
- Format triggers should be placed at the highest level possible in the object/frame hierarchy so that the trigger fires at the lowest possible frequency