Check Count Query
Prevent queries from fetching too many records.
You can limit the number of records to be fetched by a single query by setting the Check Count Query property to Yes (default No), and then setting Max No of Records to Fetch to the maximum.
The check is performed by issuing a SELECT COUNT(*) statement that meets the query conditions to the database before the actual query is send. If the resulting number of records is higher than the allowed maximum, an error message will appear:
"This query will retrieve too many rows. Please refine your search.
The maximum number of rows is <number>".
When to use
Setting the Check Count Query property to Yes is useful if you do not want the user to execute queries that will result in too many fetched records.
To prevent a query from fetching too much records:
If you set the Max No of Records to fetch property to 0 (zero), the entire table is fetched (that is, unlimited).