Max Rows

At the rpd level, you can Manage Query Execution Privileges to limit queries by number of rows received by a user or group with the max rows parameter. It determines the number of rows that can be returned from the database. If the number of rows exceeds this limit, an ODBC error occurs.

From the Administration Tool menu bar, choose Manage > Security.

• In the Security Manager dialog box, in the tree pane, select Users or Groups.
• In the right pane, right-click the name that you want to change and select Properties.
• In the User or Group dialog box, click the Permissions tab.
• In the User/Group Permissions dialog box, click the Query Limits tab and expand the dialog box to view all columns.
• To specify or change the maximum number of rows each query can retrieve from a database, in the Query Limits tab, perform the following steps:
• In the Max Rows column, type the maximum number of rows.
• In the Status Max Rows field, select a status.
• Click OK twice to return to the Security Manager dialog box.

If a query exceeds the limit set by the Administrator, the end user will get the message:

[nQSError: 60008] The query for user 'user1'
exceeded the maximum query governing rows n from the database x

Status Max Rows or Status Max Time Description

Max Time

Max Time (minutes) will not count the fetch time from database. It only counts the query execute time. For example: If your query is running for 45 seconds on database but the result fetch is taking 2 minutes, the query Max time limit won't cancel the query because your limit is 1 minute. This is because the query execution time is still less than the time limit.