Using Max Rows and Max Chars for Queries

Max Rows setting

DbVisualizer by default limits the number of rows shown in a result set tab to 20,000 rows to conserve memory. The following is displayed when this limit is reached.

If the max rows limit prevents you from seeing the data of interest, you should first consider:

1. Using a WHERE clause in the query to only retrieve the rows of interest,
2. Exporting the table to a file.

If you really need to look at more than 20,000 rows, you can change the value in the Max Rows field in the SQL Commander toolbar. Use a value of 0 or -1 to get all rows.

Max Chars setting

Text values presented in the result set grid may be very long, potentially consuming lots of memory and affecting performance. By default, DbVisualizer visually truncates text values at 1,000 characters, and when it happens, there is an indicator below the grid.

The Max Chars setting can be modified in the Tool Properties / Data Formats category or by clicking on any of the Max Chars links in the screenshot above.