Working with large data

[Amir]

Hi Haneef

While populating large data into grid, the application becomes unresponsive. Is there any threading solution to this problem or some other way of resolving this issue?

Regards,
Amir Ismail

[haneefm]

Hi Amir

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

[Lucia Diaconu]

Maybe you want to work with a virtual grid (that's what I did).

I used a BackgroundWorker and a (custom) DataRetriever class (that provides pages of data at request) and subscribed to the following events:

QueryCellInfo, QueryColCount, QueryRowCount, TpRowChanging of the grid and
DoWork, Completed of the background worker.