Rendering of grid is very slow

[Harshad]

Hi,

I am using GGC. Grid can have 4-5 groupings. when I do the grouping for more than 2 columns with summary rows. grid takes long time to render or display(load). Even scrolling is also very slow. I have grouping column as unbounded columns and populated in QueryValue event. Please can you tell me how to make grid response time better. currently grid response is almost not workable.
Also my requirement is to display grid with expanding all groups. while expanding all groups queryvalue event is fired again.
Please help me

[haneefm]

Hi Harshad,

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

Best regards,
Haneef