Currently we are using the Telerik RadGrid control to shows the data which is stored in the MOSS custom list. The volume of the data is around 2000+ . [The data may increase as the list is the task list]. The RadContorl is placed on the ASP.Net user control(.ascx page) and the same user control is used in the MOSS site as the custom web part.
When we try to open the page which contains this web part, it is taking long time(about 1 Minute) to load the page. And it is taking about 30 to 40 seconds to group and sort the data.
Data Fetch Login –
1. Get all the records from the Custom List using SharePoint APIs and store it in the DataTable object
2. Store the DataTable in the Session object for further data operations on Grid
The Properties set for the RadGrid are as follows
1. Auto Generate Columns = True
2. Allow Pagination = False
3. Allow Filtering = False
4. Allow Sorting = True
5. Allow Grouping = True
6. Allow Client Site Column Reordering = True
As per Annadatha’s suggestions we disabled the Grouping and Sorting option to check the performance, but find no success. We even tried using the GridBoundColumn (For testing purpose) and disabled “AutoGenrateColumn=False”. But no improvement in page load time.
The browser used by customer – IE6 / IE7. We also used IE8 for testing, the performance is bit good in IE8 as compared with IE6 or IE7.
And the execution time taken is
Data Fetch – About 1 Sec
Data Bind – About 0.3 Sec
Page Rendering Time – 30 Sec
Could you please let us know what could be the issue.