Performance Related issues

[Sincy Francis]

We are facing some performance issues while binding data in to the grid.For one table with 1 lakhs records its taking about 1 minutes to bind the data.Please guide me rearding this.

[Mohamed Suhaib Fahad A.]

Hi,

When we bound the grid with large amount of data we should consider about some performance factors, which are used to Optimize the performance of the Grid Engine.

Please refer the below code snippet which illustrates the above,

gridGroupingControl1.CounterLogic = EngineCounters.YAmount;
gridGroupingControl1.AllowedOptimizations = EngineOptimizations.All;
gridGroupingControl1.UseDefaultsForFasterDrawing = true;
gridGroupingControl1.BindToCurrencyManager = false;
gridGroupingControl1.InvalidateAllWhenListChanged = false;

The above statements are used increase the performance of the Grid Engine.

You can get more details of Grid Optimization from the below link:

http://www.syncfusion.com/Product/uploads/GridOptimization_8a35976c.zip

Please refer the following sample which include the Grid optimization code.

http:// websamples.syncfusion.com/samples/Grid.Windows/37026/main.htm


Please let me know if you have any other queries.

Thanks,
Fahad

[Sincy Francis]

While using the optimizegrid code in our program performance is increased but we are not able to do filtering with in the column.
how to overcome this problem.

>We are facing some performance issues while binding data in to the grid.For one table with 1 lakhs records its taking about 1 minutes to bind the data.Please guide me rearding this.

[Mohamed Suhaib Fahad A.]

Hi Sincy,

Thanks for the details.

The Filter functionality in GGC getting failed when including the DisableCounters in the AllowedOptimizations. When you set the DisableCounters, the engine detects that a table does not have RecordFilters, GroupedColumns or nested relations, counter logic will be disabled for the RecordsDetails collection since all counters are in sync with actual records (e.g. all records in datasource are shown in TopLevelGroup). With this optimization the engine does still have full support for sorting.

Please refer the sample from the below link which demonstrates the use of textbox filters (this will filter out based on each character entered),

http://websamples.syncfusion.com/samples/Grid.Windows/F68325/main.htm

You can use the above details with normal ComboBox filter type too.

Please let me know if this helps you out.

Regards,
Fahad