Results output patterns

Query Builder has two patterns for the results output:

Paginal mode

The paginal mode in Query Builder splits data into pages and is used for displaying data with a large number of records. It simplifies the overview of data and reduces database load, which in turn brings better performance.

To enable the paginal mode, click the Paginal Mode button.

Paginal mode button


The paginal mode can also be enabled by clicking the corresponding button on a message received when retrieving data from a table that has a large number of records.

To configure the number of records per page, type or select the value from the Page Row Count drop-down list. To navigate through pages, use the corresponding buttons on the document toolbar:

Paginal mode buttons


By default, the paginal mode displays 1000 records per page. You can set the paginal mode by default and specify any preferred number of records to be displayed per page on the Tools menu > Options > Data Editor > General.

If not all records are displayed on one page when the paginal mode is on, a warning icon is shown on the status bar. When you hover over the icon, a notification will be shown, informing that the data is split into pages.

Infinite scrolling

Infinite scrolling output pattern in Query Builder loads data continuously as the user scrolls down the page, eliminating the need for pagination.

All data can be fetched at once by pressing Ctrl+End. If you do so, you may get the following message:

Out of memory

Since all data is fetched to the random access memory gradually, clicking Continue may lead to the Out of Memory error.