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.

Performance Related issues

Thread ID:

Created:

Updated:

Platform:

Replies:

68325 Sep 18,2007 07:31 AM Sep 27,2007 09:25 AM General Discussion 3
loading
Tags: General Discussion
Sincy Francis
Asked On September 18, 2007 07:31 AM

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. [Syncfusion]
Replied On September 21, 2007 09:11 AM

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
Replied On September 27, 2007 12:25 AM

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. [Syncfusion]
Replied On September 27, 2007 09:25 AM

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

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.

;