4.1.2 Query Performance Considerations

For performance reasons, you should avoid using too many large queries in one report. In addition, you should only run a query from script in cases where you cannot directly bind the query. In general, it is more efficient to use the 'Data Binding' dialog box to bind the query to an element, which allows the query to automatically run as part of report generation.

There are two complimentary methods for controlling and improving the performance of a report.

Size limit: You can limit the number of rows that the query returns.

Time limit: You can limit the amount of time a query may execute.

For example, if you only use the first few rows of a query, you should set a tight limit on the query size. You can make these settings at the query level or data binding level. See Advanced Toolbar Buttons in the Data Modeling to limit at query level, and Precautions and Safeguards in the Report Design to limit at binding level.

<< 4.1.1 Running a Query from Script © 1996-2013 InetSoft Technology Corporation (v11.4) 4.1.3 Query Example >>