Slow Rendering for bulk records

[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.

[Lech Kulikowski]

Hello,

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

Thank you.

[charlvdb]

Is there any other way to get this to work?