The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
What is the best way to handle displaying very large amount of rows (up to 300 000) in a grid (GridGroupingControl) with having sorting, filtering, and formatting(QueryCellStyleInfo event) enabled?
Here are some suggestions for memory foot print: The performance of loading the data’s in the GridGroupingControl can be improved by making the child table of the Grid to load on demand. This will avoid the performance delay by loading the data’s of the child only when it is expanded or needed. A property called UseLazyUniformChildListRelation has to be set to true to make the child table load on demand.
If you have large data sources and need support for groups and filtered records you can reduce the memory footprint by disabling counters where you do not need in your application.
The auto sizing calculation for the column can be reduced to some rows so that the performance of the calculation can be increased. This has to be done by providing the FirstNRecords to the ColumnsMaxLengthStrategy, and specifying the number of record in ColumnMaxLengthFirstNRecords.
gridGroupingControl.TableOptions.ColumnsMaxLengthStrategy = GridColumnsMaxLengthStrategy.FirstNRecords; gridGroupingControl.TableOptions.ColumnsMaxLengthFirstNRecords = 50;//the number of records you want checked.