Maximum SQL result rows

This is the maximum number of rows displayed after an SQL query. The default is 1,000 rows. The allowed range is 1 to 100,000 rows.

When a result is larger, the page shows the configured number of rows and reports that the output was truncated.