Performance Issue with RadGrid and FrozenColumns

[Мarkus]

Hi,

i have an asp.net application using a radgrid. I want to froze some columns.
Everything works fine, but if I set UseStaticHeaders="true" and FrozenColumnsCount="4" the performance of our application will break down extremly.
Our data volumn is as follows: approximately 330 rows with each 55 columns. We build our grid programmatically in our code behind file.

Could you please give us an answer if it is wise to use FrozeColumns with such an data volumn and szenario? If so, please provide some performance hints.

Here the code of my aspx page:

<telerik:RadGrid ID="GridProjectProposals" runat="server" AutoGenerateColumns="false" AllowSorting="true" Height="650px" Width="1200px" GridLines="None" Skin="Windows7" AllowMultiRowSelection="True" AllowFilteringByColumn="True">
    <ClientSettings EnableRowHoverStyle="true">
        <Selecting AllowRowSelect="true" EnableDragToSelectRows="true" />
        <Scrolling AllowScroll="true" EnableVirtualScrollPaging="true" SaveScrollPosition="true" UseStaticHeaders="true" FrozenColumnsCount="4" />
    </ClientSettings>
    <MasterTableView GridLines="None" AllowNaturalSort="true" EditMode="InPlace" AllowMultiColumnSorting="true">
        <Columns>
        </Columns>
        <HeaderStyle Width="180px" />
    </MasterTableView>
</telerik:RadGrid>

Looking forward to get some ideas and your input.

Thanks ...

[Pavlina]

Hello Markus,

Please find our answer to your questions in the other thread you have open with the same subject.
To avoid duplicate posting I would suggest that we continue the discussion there.

Kind regards,
Pavlina
the Telerik team

[Мarkus]

Hi,
I attached your answer from our support ticked for a better follow up.

In your case you display very large amount of records in the grid control and you may consider using custom paging or taking advantage of the LINQ queries support of RadGrid (under .NET 3.5) to speed up the performance as much as possible. This should reduce the loading time of the control to a great extent.

Other useful tips about how to optimize the overall performance of RadGrid for ASP.NET AJAX you can find in these online resources:

http://www.telerik.com/help/aspnet-ajax/gridoverview.html (Chapter "Performance tips and tricks")
http://www.telerik.com/products/aspnet-ajax/resources/top-performance.aspx
http://www.telerik.com/support/aspnet-ajax/grid.aspx (section "Performance")
  
Please give them a try and let me know if they help to avoid the performance issue.

[Мarkus]

We had a look at your suggestions, but didn't find a way to improve the performance when using FrozenColumns.
As we reduced the number of rows, we noticed a significant performance gain, but our customer doesn't want to use pageing. Is there a way to achieve a good performance without using paging?  

When we had a lot of data (~300 rows, 50 columns), the performance is bad, but when we activated FrozenColumns it became horrible. We weren't even able to scroll through the Grid (5+ Seconds until grid responds). Reducing the amount of data improved performance, but as long as we use FrozenColumns, the performance is significant worse.
Can you please give us any advice how to improve performance in scenarios with many data and using FrozenColumns.
Thanks a lot.

[Pavlina]

Hi Markus,

To improve the performance in your case you can enable paging in the grid, but set the PagerStyle.Visible property to False so that the pager does not show. Then you can use Yahoo-style scrolling which allows you to load additional records on demand by  dragging the vertical scroll to the bottom. Refer to the online example below for additional information:
http://demos.telerik.com/aspnet-ajax/grid/examples/client/virtualscrollpaging/defaultcs.aspx 

However, I am attaching a simple website which illustrates a similar scenario and which seems to have acceptable performance on my end. Please give it a try and let me know how it goes.

Kind regards,
Pavlina
the Telerik team