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.
When a GGC has a lookup column which has huge number of records, see the street column in my attached image, the performance of loading data to the GGC is slow because even when you retrieve one record of data into the GGC, you have to load the whole lookup street table to display the street name based on the lookup street code. In my case, the lookup street table has 29,550 records for a big city. Is there any alternative way to get around the performance?
HAhaneefm Syncfusion Team October 16, 2007 08:35 PM UTC
Hi Lan,
Perfomance of the GridGroupingGrid: >>>>>>>>>>
You can refer to the \Grid.Grouping.Windows\Samples\PerformanceSamples\ category sample for improving the performance in a GridGroupingGrid. Some of the sample listed below shows you to improve perfomance.
The EngineOptimizations sample( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\EngineOptimizations ) - This sample will let you fill a grouping grid with a specified number of records and toggle various options that can affect the speed of the grid.
The GroupingPerf sample( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\GroupingPerf ) - This sample demonstrates the VirtualMode and WithoutCounter optimization.
The GroupingTraderGridTest sample( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\GroupingTraderGridTest ) - This sample demonstrates the frequent updates that occur in random cells across the grouping grid, while keeping the CPU usage at a minimum level. A timer changes cells in short intervals, inserts and removes rows.
The MarketSimulation sample( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\MarketSimulation ) - This sample demonstrates how you can do faster data updates on grouping grids while keeping the CPU usage at a minimum level.
The ManualTotalSummaries sample( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\ManualTotalSummaries ) - This sample features implementation of very simple summaries that can be updated by just applying the delta between the old and new value when a record was changed which allows for even faster updates for that specific kind of summary.
The RealtimeUpdates sample( \Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\RealtimeUpdates ) - This sample shows you how to optimize the refreshing of individual cells or summaries when an underlying datasource is frequently changed
