Page 1 of 1

Slow Rendering for bulk records

Posted: Fri Oct 10, 2025 8:28 am
by charlvdb
Hi

Using BlazorViewer and having issues rendering 100k records or more.
System memory eventually runs out, and I need to close the browser.

Business Objects are used, the object is filled with data via Postgresql; This loads quick, but when rendering it slows down.
Is it possible to only load 1000 records at a time, then on scroll or page skip/next the next bunch of 1000 rows are rendered on the report?
An API is used to send the report parameters through to the repository, resultset is returned and assigned.

Code: Select all

var report = new StiReport();
 report.LoadFromString(assembly.ReadResource("TransactionList.mrt"));

// Simulate 100k rows
var data = new List<TransactionList>(100_000);
for (int i = 0; i < 100_000; i++)
    data.Add(new TransactionList());
    
 report.RegBusinessObject("TransactionListReportData", data );
 await report.RenderAsync();
 
 
We are using ServerSide Rendering in Blazor.
Any other suggestions are welcome.

Re: Slow Rendering for bulk records

Posted: Fri Oct 10, 2025 8:56 am
by Lech Kulikowski
Hello,

Unfortunately, no, it is no possible. All data should be loaded before report rendering.

Thank you.

Re: Slow Rendering for bulk records

Posted: Fri Oct 10, 2025 9:01 am
by charlvdb
Is there any other way to get this to work?

Re: Slow Rendering for bulk records

Posted: Mon Oct 13, 2025 10:08 am
by Lech Kulikowski
Hello,

Split your data into several parts, render multiple reports, and then merge its into one.

Thank you.

Re: Slow Rendering for bulk records

Posted: Thu Nov 13, 2025 5:13 am
by charlvdb
A solution that worked great for me was changing:

Code: Select all

Options.Toolbar.ViewMode = StiWebViewMode.Continuous 
to
Options.Toolbar.ViewMode = StiWebViewMode.SinglePage;
1 Page displayed at a time now, instead of all.

This cut the speed from 11sec loading down to 5sec.
Also, moving calculated columns and totals to my datasource instead.

Re: Slow Rendering for bulk records

Posted: Fri Nov 14, 2025 3:52 pm
by Lech Kulikowski
Hello,

Thank you for the information.