Results output patterns
dbForge Transaction Log has two patterns for the results output:
The guide also provides an output patterns comparison table between paginal mode and infinite scrolling.
Paginal mode
The paginal mode divides data into pages, allowing for the display of a large number of records. The mode simplifies data review and reduces database load, enhancing overall performance.
On the Data Editor toolbar, click Paginal Mode to activate the paginal mode.
Note
You can also activate the paginal mode by clicking the corresponding control upon receiving a message while retrieving data from a table.
To configure the number of records per page, type or select the value from the Page Row Count dropdown list. To navigate through pages, use the corresponding buttons on the document toolbar:
Note
By default, the paginal mode displays 1000 records per page. You can change the number of records to be displayed per page on the Tools menu > Options > Data Editor > General.
A warning icon is shown on the status bar if not all records are displayed on one page when the paginal mode is on. When you hover over the icon, you will get a notification, informing you that the data is split into pages.
Infinite scrolling
Infinite scrolling output pattern loads data continuously as the user scrolls down the page, eliminating the need for pagination.
You can fetch all data by pressing Ctrl+End. However, this action may lead to the Out of Memory exception. You can choose to continue retrieving data, cancel retrieving data, or turn on the paginal mode.
Output patterns comparison table
Both paginal mode and infinite scrolling have their advantages and disadvantages:
Paginal mode
| Pros | Cons |
| Faster data retrieval | Scrolling required for full data view |
| The paginal mode view can help to speed up data retrieval times since only a limited number of records are displayed on each page. This can be particularly helpful when dealing with large datasets. | The paginal mode requires users to navigate through multiple pages to view all table data, making it difficult to get a complete overview of the data at once. |
| Less load on database server | Export limitations |
| When using the paginal mode, the number of records displayed on each page is limited, which means that the database server is only queried for a subset of the data at a time. | When using the paginal mode, data export from the grid is limited to only the data displayed on the current page, which can be a drawback for users who need to export larger datasets. |
| Lower RAM usage | Count limitations |
| In the paginal mode, only a limited number of records are loaded into memory at any given time, typically the records displayed on the current page and a few surrounding pages. | The paginal mode does not show immediate record count, but users can find it by clicking “Go to last page” in the paginal mode control located on the Data Editor toolbar. |
| Lock-free SELECTs | Limited sorting options |
| When executing a SELECT statement, the paginal mode does not lock tables for DDL (Data Definition Language) operations. | The paginal mode can limit the available sorting options to those that apply only to the currently displayed page rather than allowing for sorting across the entire dataset. |
| Ease of navigation | Limited searching options |
| By breaking the dataset into smaller, more manageable pieces, the paginal mode can make it easier for users to navigate and find the specific data they need. | Users may need multiple searches on each page rather than across the entire dataset when searching for particular data in a paginated view. |
Infinite scrolling
| Pros | Cons |
| Less load on database server | Locked SELECTs |
| When using infinite scrolling, the data is selected as it is scrolled, which means that the database server is only queried for a subset of the data that it currently being viewed. | Infinite scrolling locks tables for DDL (Data Definition Language) operations when executing a SELECT statement. |
| Full data export | Increased RAM usage |
| When using infinite scrolling, the user can export all the data directly from the grid without being limited to the records displayed on the current page. | Infinite scrolling requires the local computer to load more data at a given time period, which means a heavier load on RAM. |
| Better user experience | Increased chances of memory overflow |
| With infinite scrolling, users can continuously scroll through content without manually clicking to load new pages, providing a more seamless experience. | Selecting and viewing large amounts of data from an SQL database can cause memory overflow due to the limited capacity of the computer’s memory to handle and store the data. |
| Reduced clicks | Less control |
| Infinite scrolling can reduce the number of clicks required to navigate through the data, saving time and increasing efficiency. | With infinite scrolling, users cannot easily navigate to specific parts of the dataset, and the scroll position can be easily lost. |