Bold Reports® performance metrics
Bold Reports® On-Premises Edition performance tests measure how the system renders large reports and how it behaves under concurrent user load.
What do the Bold Reports® performance tests measure?
Performance testing of Bold Reports® On-Premises Edition measured how the system performs when rendering large reports. The results follow.
The tests also evaluate how the system behaves under concurrent user load, providing a comprehensive view of both report rendering performance and server-side stability. The results help you assess Bold Reports® stability, responsiveness, and scalability in real-world usage scenarios.
How fast does Bold Reports® render large reports in On-Demand Mode?
Bold Reports® On-Demand Mode is designed to optimize responsiveness when working with large datasets. The performance evaluation began with testing how Bold Reports® handles report rendering in On-Demand Mode.
Enabling On-Demand Mode significantly improves performance by rendering only the visible portion of the data initially, allowing faster access to the first page.
Test Environment Configuration
The Bold Reports® On-Demand Mode tests used the following environment:
-
RAM: 16 GB.
-
Processor: 4 vCPUs.
-
Deployment: Azure Virtual Machine.
-
Report Name, Settings: Flat table report with 10 columns.
-
Property settings: On-Demand (PageCreation → Background).
Performance Results
The following table compares Bold Reports® first page time and query execution time in Standard Mode and On-Demand Mode.
| Records | First Page Time (Standard Mode) (mm:ss:ms) | First Page Time (On-Demand Mode) (mm:ss:ms) | Query Execution Time (Standard Mode) (mm:ss:ms) | Query Execution Time (On-Demand Mode) (mm:ss:ms) |
| 100K | 00:11:15 | 00:03:04 | 00:01:970 | 00:00:251 |
| 500k | 00:36:18 | 00:02:88 | 00:03:415 | 00:03:415 |
| 1M | 01:17:69 | 00:10:34 | 00:05:664 | 00:00:249 |
| 1.5M | 01:56:60 | 00:02:87 | 00:19:200 | 00:00:249 |
| 1.7M | 01:58:16 | 00:02:87 | 00:13:156 | 00:00:266 |
| 2M | 02:20:66 | 00:06:56 | 00:15:197 | 00:00:255 |
The results confirm that On-Demand Mode significantly reduces the initial load time, even for reports containing over 2 million records.
-
To learn about enabling On-Demand Mode and best practices for large dataset rendering, see View Millions of Data - Best Practices.
-
For further details, see the On-Demand Mode limitations documentation.
General Performance Metrics
The following table outlines the performance metrics of Bold Reports® during report rendering with various row and column counts. The time taken shows how long it takes to load the specified number of records.
Representative Performance for Various Data Sizes:
| Column Count | Row Count | First Page Time (mm:ss:ms) | Query Execution Time (mm:ss:ms) |
| 10 | 1K | 00:03:29 | 00:00:895 |
| 10 | 50K | 00:03:26 | 00:00:254 |
| 10 | 100K | 00:02:73 | 00:00:254 |
| 10 | 1M | 00:02:58 | 00:00:246 |
| 20 | 10K | 00:03:33 | 00:00:492 |
| 20 | 200K | 00:03:56 | 00:00:242 |
| 20 | 1M | 00:03:64 | 00:00:238 |
Note: As you can see, the time taken increases with the row count, particularly for larger datasets (100K or more). The trend highlights the system’s performance when handling large datasets.
Complete Performance Data Table
The full Bold Reports® rendering dataset is shown below for more granular details.
| Column Count | Row Count | Records | Time Taken (mm:ss:ms) | Query Execution Time (mm:ss:ms) |
| 10 | 1K | 1K | 00:03:29 | 00:00:895 |
| 10 | 10K | 10K | 00:02:94 | 00:00:234 | 10 | 20K | 20K | 00:02:83 | 00:00:237 |
| 10 | 50K | 50K | 00:03:26 | 00:00:254 |
| 10 | 100K | 100K | 00:02:73 | 00:00:254 |
| 10 | 200K | 200K | 00:03:27 | 00:00:284 |
| 10 | 300K | 300K | 00:03:12 | 00:00:287 |
| 10 | 400K | 400K | 00:30:30 | 00:00:287 |
| 10 | 500K | 500K | 00:04:47 | 00:00:247 |
| 10 | 1M | 1M | 00:02:58 | 00:00:246 |
| 20 | 1K | 1K | 00:03:00 | 00:00:240 |
| 20 | 10K | 10K | 00:03:19 | 00:00:251 | 20 | 20K | 20K | 00:03:19 | 00:00:251 |
| 20 | 50K | 50K | 00:03:89 | 00:00:249 |
| 20 | 100K | 100K | 00:03:21 | 00:00:241 |
| 20 | 200K | 200K | 00:03:56 | 00:00:242 |
| 20 | 300K | 300K | 00:03:06 | 00:00:246 |
| 20 | 400K | 400K | 00:03:47 | 00:00:227 |
| 20 | 500K | 500K | 00:02:90 | 00:00:229 |
| 20 | 1M | 1M | 00:03:64 | 00:00:238 |
How does Bold Reports® perform under concurrent user load?
Bold Reports® load testing simulated concurrent users to evaluate how Bold Reports® On-Premises Edition performs under load. Load testing shows how the system handles real-world scenarios where multiple users access and interact with reports at the same time.
The tests were conducted in Kubernetes environments using different machine configurations to evaluate application scalability, stability, and responsiveness under increasing workloads.
The load testing was performed using the following configurations:
-
100 concurrent users: 4 vCPUs and 16 GiB RAM.
-
250 concurrent users: 2 worker nodes, each with 4 vCPUs and 16 GiB RAM (8 vCPUs and 32 GiB RAM total), using a multi-container deployment.
The goal of these tests is to help you understand how Bold Reports® On-Premises Edition performs under stress, so you can assess its stability and responsiveness when multiple users access it at the same time.
Test Setup and Key Parameters
The following table lists the key Bold Reports® load test parameters for each configuration, including the number of concurrent users, test duration, and the settings used to simulate the load.
| Property | 100 Concurrent Users | 250 Concurrent Users | Explanation |
| Concurrent Users | 100 | 250 | Total users accessing reports simultaneously. |
| Ramp Up Period (seconds) | 50 | 60 | Controls how users are gradually introduced during the load test. |
| Loop | 1 | Continuous | Specifies how many times the test scenario is executed. |
| Thread Life Time (seconds) | 700 | N/A | Maximum duration of the test; ends after the set time, even if incomplete. |
| Startup Delay (seconds) | 2 | 2 | Initial delay before the test starts, to handle setup time. |
| RunTime Controller Runtime (seconds) | 480 | 90 | Limits how long the test runs before stopping, applied to child elements. |
| Flow Control Action Pass Duration (seconds) | 3 | 2 | Controls the delay between consecutive requests sent to the application during the load test. |
Tested Actions
The 250 concurrent user load test included the following actions:
- Report Load
- Report View
- Report Update
- Report Download
- Report Export
Load Test Results
The Bold Reports® load test results highlight the system’s stability under concurrent user load:
| Test Run | Success Rate (100 Users) | Success Rate (250 Users) |
| 1st Run | 100% | 100% |
| 2nd Run | 99.55% | 100% |
| 3rd Run | 99.91% | 99.78% |
These results show that Bold Reports® On-Premises Edition maintained stable performance under concurrent user load across different deployment configurations.
Frequently asked questions
How much faster is the first page in On-Demand Mode?
In the Bold Reports® tests, the first page for 2M records took 02:20:66 in Standard Mode and 00:06:56 in On-Demand Mode (mm:ss:ms).
What success rate did the concurrent load test achieve?
With 100 concurrent users, Bold Reports® achieved success rates of 100%, 99.55%, and 99.91% across three test runs. With 250 concurrent users, the success rates were 100%, 100%, and 99.78%.