Optimize Report Performance with FetchLimit and PageCreation in Bold Reports
In Bold Reports, handling large datasets efficiently requires proper configuration of the FetchLimit and PageCreation properties. FetchLimit ccontrols the maximum number of records retrieved from the data source, reducing load on both the server and database. PageCreation determines how report pages are rendered and delivered, allowing you to balance initial load time with smoother navigation. Adjusting these settings can significantly improve report performance and the overall user experience.
Steps to Configure FetchLimit and PageCreation
Step 1: Access the Manage Sites Page
-
On the Reports page in the Bold Reports Server, click the profile icon.
-
Select Manage Sites (Admin Access) from the menu.
Step 2: Open Configuration Settings
-
In Manage Sites section, click the Settings icon.
-
Choose Configuration.
-
Select the
reporting/config.xmlfile from the dropdown.
Step 3: Modify the Configuration File
-
Open
reporting/config.xmlin the editor. -
Locate the
<ReportViewerFeatures>tag. -
Add or update the following within
<ReportViewerFeatures>:<PerformanceSettings FetchLimit="100" PageCreation="OnDemand"/> -
Save the file.
Configuration Options
| Property | Value | Description |
|---|---|---|
FetchLimit |
e.g., "100" |
Sets the maximum number of records fetched from the data source. Example: Use 1000 for large datasets to balance performance and completeness. |
PageCreation |
"Default" |
Renders all pages upfront. Suitable for small reports; increases initial load time for large datasets. |
PageCreation |
"OnDemand" |
Renders and delivers the first page immediately. Subsequent pages load only when navigated to. Recommended for large datasets. |
PageCreation |
"Background" |
Renders the first page quickly, while remaining pages load in the background with a progress indicator. Provides a balance between speed and user feedback. |
Tip: For datasets with millions of records, combine
PageCreation="OnDemand"withFetchLimit="1000"for optimal performance.
Step 4: Test the Configuration
- Restart the Bold Reports Server to apply changes.
- Open a report in the Report Viewer.
- Verify:
- Only the configured number of records (e.g., 100) are displayed.
- Page load time and navigation are improved, especially when using
OnDemandorBackgroundmodes.
Conclusion
Configuring FetchLimit and PageCreation in Bold Reports Server helps optimize performance by managing data retrieval and page rendering. These settings ensure faster report loading and deliver a smoother experience for users, especially when working with large datasets.
