Incremental loading, or lazy loading, is a new feature in the v2017.2 release of Exago BI. Incremental loading allows you to set limits on the amount of data that is returned for each database query, and allows users to load reports incrementally, starting with a small set of rows, and adding more in steps as desired.
This can be useful for shortening the amount of time it takes a report to load and be usable. It can also help reduce contiguous load on a database which may improve load balancing performance.
Incremental loading is disabled by default. To enable it, the following configuration setting has been added which controls the maximum number of rows that can be returned for each database query:
( Database Settings ) Row Limit Step Size
This value sets the initial number of rows returned when the report is first executed, as well as the number of rows returned for each subsequent query.
With incremental loading enabled, when an ExpressView is run or a report is run in the Report Viewer (the interactive toolbar must be enabled), the report will only query the first number of rows specified in the configuration setting. If there are fewer rows than the full data set, an alert icon displays on the toolbar with the message "Truncated results displayed".
Alert icon in Report Viewer
Alert icon in ExpressView
Click the icon to show a menu with two options for retrieving more data:
- Generate +number to retrieve the next number of rows and add them to the report. (The number is determined by the aforementioned Row Limit Step Size setting).
- Generate All to get the full data set.
Note: Exporting a truncated report from the Report Viewer generates a file with only the existing rows.
Incremental loading has no effect on Dashboards, Chained Reports, or Scheduled Reports. Exporting from the Report Tree and Advanced Report Designer is not affected by incremental loading.