Enabling Row Limit and Query Timeout

You can limit the number of rows that are displayed in your report. You can also limit the number of seconds a query runs before a timeout occurs. Imposing row limits and timeouts on queries is important to avoid out of memory errors or processes that consume too many resources on the database server. (Default value for row limit is 1,000. Default value for Query Timeout is none.)

Both options are available in the Query Setup dialog box. In the Data tab, click the small icon on the upper right corner to open the Query Setup dialog box. Make your changes as needed and close the dialog box when you are done.

Open topic with navigation