[Solved] Very slow performance with column datatemplates

[Thys]

We originally transitioned our application to Telerik controls mainly to get the benefit of the RadGridview component. However, we had to change back to using the silverlight toolkit datagrid due to the extremely slow performance of the Telerik RadGridView when using datatemplates for the columns. Is there any way to improve / optimise it to remotely get the same performance as the toolkit version of the gridview?

 We use the gridview to display data across a user selectable date range. The columns are created dynamically in code with a template determining how the data is presented in the grid cell. The slow performance does not seem to be related as much to the number of rows as to the number of columns. Typical usage would use a date range of a month, resulting in about 30 columns with templates + another 5 to 10 static columns (without templates). We rarely in this use case have more than a couple of 100 rows, but it takes anything from 3 to 5 seconds to respond to a single click to scroll up or down. This is way slower than what is acceptable. The toolkit gridview responds instantaneously for the same data set.

 Is this normal? Is there any way around this?

 

[Ivan Ivanov]

Hello Thys,

Although RadGridView is the more complex of the two controls we are aiming for comparable performance between it and the MS DataGrid. I have prepared a sample project, taking into account your the parameters you provided, but no significant difference can be observed. Can you please share whether there are any notable differences between your project and mine? Do you test both controls in a similar layout setting (host panels, data templates structure etc)?

Regards,
Ivan Ivanov
Telerik

 

 

[Thys]

I agree that with the sample provided there is no difference. I subsequently went back to our application and tried the RadGridView again, noticing a substantially slower performance. After some more investigation it seems to be mainly related to groupings. As soon as we use a PagedCollectionView as the grid data source with one or two group descriptions, the performance is reduced. It specifically manifests itself in the scrolling. When the user clicks on the vertical scrollbar there is a noticable lag on the RadGridView which is not present on the original grid. I can provide a sample project which demonstrates this.

[Ivan Ivanov]

Hello,

I am glad to hear that you managed to isolate this behavior. Can you please send us the sample project that you mentioned? You can do this through our tickets system, which supports archive attachments up to 20 mb. We will debug it on our side to pinpoint the source of the issue.

Regards,
Ivan Ivanov
Telerik