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.
Unfortunately, activation email could not send to your email. Please try again.

Lookup Column table loading performance

Thread ID:

Created:

Updated:

Platform:

Replies:

69115 Oct 15,2007 02:27 PM Oct 16,2007 04:35 PM Windows Forms 1
loading
Tags: GridControl
Lan Mo
Asked On October 15, 2007 02:27 PM

Hi,

V4.4.0.51 & VS2003

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?

Thanks,


Lan

haneefm [Syncfusion]
Replied On October 16, 2007 04:35 PM

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

Best regards,
Haneef

CONFIRMATION

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.

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.

;