Using Max Rows and Max Chars in the Data tab

Max Rows setting

DbVisualizer by default limits the number of rows shown in the Data 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 Filter 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 grid status bar. Use a value of 0 or -1 to get all rows, or a specific number (e.g., 5000) to set a new limit.

Max Rows at First Display

By default, opening the Data tab for a table loads all rows, unless there is a Max Rows limit. If you have very large tables and don't want to risk memory issues if you accidentally open the Data tab and have no Max Rows limit, you can specify a Max Rows at First Display limit. You do this in the Tool Properties dialog, under the General / Table Data category.

The default is -1, which means no limit. If you set it to a positive number, only the specified number of rows are loaded when the Data tab is first opened for a table. To load more rows, up to the Max Rows setting in the Data tab, click the Reload button in the Data tab toolbar.

Max Chars setting

Text values presented in the Data tab 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 below.

Along with the highlighted field, a warning pops up close to the field. You can disable this behavior in the Tool Properties dialog under the General / Grid category.