[Solved] Low Grid performance on hiding/unhiding columns and scrolling for vast data sets

[Michał]

Hello Telerik,

We have a couple of Grids that display relatively high volumes of data: 30+ columns with 700+ rows. The issue we're facing is that unhiding a hidden column take significant amount of time. Whereas it takes 2-3 seconds to hide a column, but it take over a minute to bring it back. Obviously the customer finds this unacceptable.
Another issue is scrolling - when pulling scrollbards, before reaching the other end of the Grid they tend to get stuck a few times for a second or so.

Here's how our grids are configured: 
 

Html.Telerik().Grid<GridDataApp.Models.Grid1Data_Result>()
        .Name("AppGrid1")
        .DataBinding(dataBinding => dataBinding.Ajax().Select("_AjaxBinding", "User", @ViewBag.ID).Update("_SaveBatchEditing", "User", @ViewBag.ID))
        .DataKeys(keys => { keys.Add(p => p.RowID); })
        .Editable(editing => editing.Mode(GridEditMode.InCell))
        .Columns(columns =>
        {
            columns.Bound(o => o.CategoryColor).Title("").Width(columnSettings.Find(c => c.Name == "CategoryColor").Width).ReadOnly(true).Filterable(false);
            <Bound columns list>
        })
        .Scrollable(scroll => scroll.Height("635px"))
        .Filterable()
        .ColumnContextMenu()
        .Resizable(resizing => resizing.Columns(true))
        .NoRecordsTemplate("Loading data, please wait...")
        .ClientEvents(events => events.OnRowDataBound("onGrid1RowDataBound").OnLoad("onGrid1Load").OnDataBound("onGrid1DataBound")
            .OnDataBinding("onGrid1DataBinding").OnEdit("onGrid1Edit").OnSubmitChanges("onGrid1Submit").OnColumnShow("onGrid1ColumnToggle")
            .OnColumnShow("onGrid1ColumnToggle")))

 
What can be done to optimize the performance?

Thanks is advance,
Michal

[Michał]

Any comments, Telerik Team?

It's slow by design, you have too many columns, try to avoid unhiding columns, talk your customer into using paging, there's a hidden switch to boost performance, but it's a secret? :)

Cheers,
Michal