|
|
|
|
|
Specifies the number of rows to display when a query is run, or when a table is displayed. You may just wish to set this to the maximum value, however be very aware that when you set this to a large value your queries will take a long time to run and more memory will be used.
Our recommendation is to set this to a low value (200) and just change this to a higher value on the (rare) occasions when you want to see a lot of rows.
Warning: if you set this to No Limit, and display a very large number of rows, your machine can run out of memory. Use this with caution. For this reason, AQT will warn you if you use this setting.
If you are running the Evaluation version of AQT you will not be able to increase this beyond 50 rows.
The issue here is similar to Max Rows Displayed. This option exists to minimize the amount of memory used to store the result of the query. This option determines the maximum size of a column held in the result-set.
Our recommendation is to set this to a low value (50 or 200) and change this to a higher value only when you wish to see the full text of your large columns.
Note if you use a value of 100000, large column values may display as blank in the Data Display window. This appears to be a peculiarity / bug of the display grid in that values larger than 60000 bytes display as blank. If you right click a value and select View, you will see the full value.
For displaying the full value of large columns (such as LOBs), it is recommended that you use Options > LOB Options > Write LOBs to Files.
If you are running the Evaluation version of AQT you will not be able to change the Max Column Size value.