Creating reports and dashboards | Stimulsoft community forum

Hi,
We are in the process of testing the performance of Stimulsoft Reports.JS and I was wondering if the results we are seeing are consistent with what should be expected. If they are not, can you highlight results which would be different to what you would expect. We will be making some application design decisions based on these test results and would like to make sure we are using correct data when making those decisions.

2 graphQL end points were created for the test which returned identical data with one being in a hierarchial format and the other in a flattened format. The raw size of the JSON data is approximately 11MB with approximately 22 thousand rows when the data is flattened. The time for the Hierarchial data API call to execute is approximately 3 seconds. The time for the flattened data API call to execute is approximately 1 second.

The following results are the times taken for both the data and report definition to be loaded into the Stimulsoft Reports.JS control from API function calls and the the control to complete rendering the report. There are definitely some areas where we can make speed improvements in the way we load everything, but, I would expect this would give us a maximum of a 1 second improvement.

Hierarchical Data Source

1. Double grouped report displaying 5 fields of data - 20-25s


Flattened Data Source

1. Double grouped report displaying 5 fields of data - 11s

2. Report displaying 5 fields of data - 12s

3. Report displaying 3 fields of data - 8s

4. Report displaying 1 field of data - 5s


Our conclusions from this are
1. A hierarchical JSON data source is processed by the Stimulsoft Reports.JS control much more slowly than a "flattened" JSON data source.
2. The speed of displaying a report is directly proportional to the amount of data on the report - a combination of number of rows and columns.

Could you please advise if the above test results are as expected and our conclusions are correct.

Thanks

Daniel Hewett

Hello,

> 1. A hierarchical JSON data source is processed by the Stimulsoft Reports.JS control much more slowly than a "flattened" JSON data source.

Please send us a sample report with test data that reproduces the issue for analysis.

> 2. The speed of displaying a report is directly proportional to the amount of data on the report - a combination of number of rows and columns.

Yes.

Thank you.

Hi,

Attached are 2 projects which use the stimulsoft viewer, 1 for each Hierarchical and Flattened data source.

The JSON datasource and the report definition are both embedded into the the project.

The reports should be identical as far as general structure and fields displayed.

The data should be identical, however, note that more pages are displayed on the flattened report as the hierarchical report will only display employee records that have leave history data. Is it possible to write a report based on a hierarchical data source like this that does display all employees and not just those with leave history data?

The testing results that we get are:
Flattened - 9.5s
Hierarchical - 16.5s

Any feedback on the test results and not showing all data for the hierarchical report would be appreciated.

Thanks

Hello,

Thank you for samples.
We need some time to investigate the issue, we will let you know about the result.

Thank you.

Hello,

We have added some optimizations. Now flattened 7.5 s, hierarchical 9.5 s
It will be available in the next release build.

Thank you.

Hello,

About the demo, the report -> Insure by Country report

.net takes around Finish - 2 seconds to view
Js takes around 6 seconds.

All other reports do the same.

Is stimulsoft faster in .net than in JS?

Thank you.

Hello,

Yes, the net-engine is faster.

Thank you.