We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Working with large data

Thread ID:





64828 Jul 24,2007 11:11 AM UTC Jul 25,2007 07:32 AM UTC WinForms 2
Tags: GridControl
Asked On July 24, 2007 11:11 AM UTC

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?

Amir Ismail

haneefm [Syncfusion]
Replied On July 24, 2007 06:49 PM UTC

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\\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\\windows\Grid.Grouping.Windows\Samples\PerformanceSamples\GroupingPerf )
- This sample demonstrates the VirtualMode and WithoutCounter optimization.

The GroupingTraderGridTest sample( \Syncfusion\Essential Studio\\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\\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\\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\\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,

Lucia Diaconu
Replied On July 25, 2007 07:32 AM UTC

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.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon