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

GroupingGridExcelConverterControl Performance Issues

Thread ID:





92419 Jan 13,2010 08:38 PM UTC Jan 19,2010 12:39 PM UTC ASP.NET Web Forms (Classic) 1
Tags: GridGroupingControl
Trevor Robinson
Asked On January 13, 2010 08:38 PM UTC

We are encountering performance problems with larger datasets. We are working with record numbers in the 5-11k range with around 5-6 rows grouped per record.

If I try to export a dataset that is larger than the row size maximum to the Excel 97-2003 format it throws an index out of range error as expected. This takes only a couple minutes. However, when I delete enough records to bring the file below this limit it then takes 20-30 mins to finally generate the file. When we export the original data to Excel 2007 format (The row count is lower than the 2007 maximum), it also takes the same increased time.

Interestingly, when I delete enough records to bring the dataset down to about half, the file is complete after just 3-5 mins. It appears that this performance change has a nonlinear relationship to the number of records.

I am curious if anyone else has experienced similar problems when working with large sets of data and this control. Also, I am wondering if there are any settings changes we can make to the GridGroupingControl to make this conversion process faster.

Sorry if my post is too general about my problem. Let me know if there is anything that needs clarification.

Jaffersathick B [Syncfusion]
Replied On January 19, 2010 12:39 PM UTC

Hi Trevor,

Thank you for using Syncfusion products.

The reported issue is already known performance issue. We currently working on the issue. The fix for this issue will be available on next major release - Essential studio 2010 volume 2.

Let me know if you have any queries.



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

or the page will be automatically redirected to 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