About designing workbooks for maximum performance

Whether you are using Discoverer Plus Relational to perform ad hoc queries, or to create reports for other end users, you want to minimize the time it takes to run queries and reports. By following a few simple design guidelines, you can maximize Discoverer performance.

Where possible:

• use tabular reports rather than cross-tabular reports

• minimize the number of page items in reports

• avoid wide cross tabular report

• avoid creating reports that return tens of thousands of rows

• provide parameters to reduce the amount of data produced

• minimize the number of worksheets in workbooks

• remove extraneous worksheets from workbooks (especially if end users frequently are Discoverer's export option, see Notes below)

Notes

• When end users export data in Discoverer Plus Relational or Discoverer Viewer, they can export either the current worksheet or all the worksheets. In other words, they cannot selectively choose the worksheets to be exported. Remove extraneous worksheets so that extra data is not included when end users export all worksheets.