Report Viewer Loads Slowly with Large Datasets in ASP.NET Core

[minormemor]

Hello everyone,

I'm currently working with Stimulsoft Reports.WEB in an ASP.NET Core application and I've encountered a performance issue that I'm not sure how to solve.

I have a report that displays data from a SQL Server database. The report works correctly, but when the dataset contains more than 20,000 records, the viewer takes a very long time to load. In some cases, users need to wait more than 30 seconds before the report becomes available.

I have already tried:

Optimizing SQL queries
Reducing the number of report components
Enabling report caching
Testing on a production server with sufficient resources

Unfortunately, the loading time is still quite high.

My questions are:

Are there any recommended settings in Stimulsoft Reports.WEB for handling large datasets?
Is it better to use server-side report generation instead of loading everything in the viewer?
Does Stimulsoft provide any best practices for improving report rendering performance with large reports?

Any suggestions or examples would be greatly appreciated.

Thank you in advance for your help.

[Lech Kulikowski]

Hello,

> Is it better to use server-side report generation instead of loading everything in the viewer?

Yes.

> Any suggestions or examples would be greatly appreciated.

Also, please see the following articles:
https://www.stimulsoft.com/en/blog/arti ... ng-reports
https://www.stimulsoft.com/en/blog/arti ... rts-part-2
https://www.stimulsoft.com/en/blog/arti ... rts-part-3

Thank you.