Specifying Limits resource limits
On the Limits page of the Edit Resource Limits Group Schedule window you set the warning and cancellation limits for the maximum number of rows and bytes of data that can be retrieved from the database data source. In addition, you can specify the maximum number of simultaneous connections that can be established to the data source.
Limits resource limits can be set for data sources. The Limits resource limits are as follows:
- Maximum Rows to Fetch
- These fields specify the limits for the number of rows of data that can be retrieved from a database data source when running a query. The Warning limit field specifies the number of rows that can be retrieved from the data source before you are notified that a row limit has been reached. The user is prompted to select whether more data should be fetched or should the query be canceled. The Cancel limit field displays the number of rows that can be retrieved from the data source before the row limit is reached. The query is then automatically canceled.
- Maximum Bytes to Fetch
- These fields specify the limits for the number of bytes of data that can be retrieved from a database data source when running a query. The Warning limit specifies the number of bytes that can be retrieved from the data source before the user is notified that the byte limit has been reached. The user is then prompted to specify whether more data should be fetched or should the query be canceled. The Cancel limit displays the number of bytes that can be retrieved from the data source before the byte limit is reached. The query is then automatically canceled.
- Maximum Connections
- This field specifies the limit for the number of simultaneous connections that can be
established to a database data source. The Cancel limit specifies the number
of simultaneous connections that can be established to a data source before the query requesting the
next connection is automatically canceled. Setting the limit to zero (0) indicates that there is no
limit to the number of connections.
Generally, connections to database data sources are reused. If you run one query at a data source, then run another query at the same data source, only one connection is required. However, if you run those two queries simultaneously, then two connections are required. If another connection to a data source is required and this limit is reached, an error is returned and the operation is not performed.
Note: To enable table editing, you must specify that two or more simultaneous connections are allowed.