RadGrid control in SharePoint 2010_Load Delay Issue

[PCR]

Hi Team,

 

We have implemented a RadGrid control in SharePoint 2010. As per the requirements specified, this control has to retrieve huge number of records from DataTable.  And we don't use paging and virtual scrolling for RadGrid.

The problem we are facing in this RadGrid Control is that rendering from Client Side is taking long time in the browsers especially in IE. The Client Side is taking more time to render in the grids than the Server Side code.

For example :  We are rendering 4555 records and it takes morethan 25 seconds to load the controls.

   Initially blank page appears and only after 10 seconds the Radgrid control appears on the page. But we are not able to access the features of RadGrid (E.g: Scrolling, Row hovering, Row clicking).

   Because, the control hasn't rendered the page completely.

   The control takes minimum 25 seconds to render the age. Also we tried to open the page in "SharePoint Modal popup", but it takes longer time than adding as web part. The below given are the benchmarks for loading the grid in the browsers.

 

 

IE 8    Show Grid 5 Secs - Total Page Load Time 25 Secs

IE 9    Show Grid 25 Secs -  Total Page Load Time 25 Secs

IE 10   Show Grid 5 Secs -   Total Page Load Time 7 Secs

FireFox(16.0.2)  Show Grid 3 Secs - Total Page Load Time 8 Secs

Chrome(30.0.1599.22) Show Grid 2 Secs - Total Page Load Time 6 Secs

Sharepoint Version: 14.0.6137.5000      Telerik version: 2013.2.611.35

Attached is a document which provides the benchmarks of browsers using Fiddler tool and a Wsp that has RadGrid Control and some sample records to replicate the issue in the SharePoint environment. Please download from the below link.

       WSP: https://www.dropbox.com/s/1duip123w68zo83/PerformanceTest.zip

Document: https://www.dropbox.com/s/0w5etx4l2k2y6ri/Telerik%20Grid_Performance_SharePoint%202010.docx

Please suggest to reduce the time delay. 

Thanks in Advance

[Maya]

Hello Robert,

Will it be possible to confirm whether you are working with RadGridView for Silverlight or RadGrid for ASP .Net Ajax ?

Regards,
Maya
Telerik

[PCR]

Hello Maya,

Thanks for the reply. We are working with RadGrid for ASP .Net Ajax and using this in SharePoint 2010 environment.


Thanks

[Tsvetoslav]

Hi Robert,

I am afraid the only solution is to use paging for the grid as 4555 rows is a huge rendering and no browser can speedily handle as much.
 
Regards,
Tsvetoslav
Telerik