Large dataset support for Grouping Grid

[Dan Dzina (CyberSavvy)]

Are there any examples of using the gridgroupinggrid with very large result sets? While our implementation of the grid works very well on small to moderate result sets, once we are beyond 30-50k rows it becomes very memory and processor intesnive -- nearing 200-300k I have even seen OutofMemory exceptions on some high end machines.

In this case, we are considering conditionally failing back to the GridDataBoundGrid, however I am curious if there is some compromise of features in the grouping grid that would allow us to continue to leverage the investment in formatting/layout/etc in the groupinggrid implementation

[haneefm]

Hi Dan,

The GroupingPerf browser 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. You can specify whether the records should be sorted, if maximum column width should be calculated and/or use a custom sort routine.

Path : \Syncfusion\EssentialStudio\5.1.1.0\Windows\Grid.Grouping.Windows\Samples\2.0\PerformanceSamples\GroupingPerf\cs

Best regards,
Haneef