RadGridView DataBinding is too slow

[Denny]

Hallo,

I'm using the RadGridView for our business applications.
But our users are complaining that the data will not be loaded quickly.
So I've made ​​some comparative tests with a regular DataGrid and found out that the DataGrid binds data much faster than the RadGridView.

Loadingtime of 50000 Datarows with 8 Columns: 17 miliseconcs.
Binding to a DataGrid: 120 milliseconds. Used Memory: 7 MByte.
Binding to a RadGridView: 4 seconds. Used Memory: 51 MByte.

Are there any settings in RadGridView to get the same performance as a DataGrid?

I used following xaml for the RadGridView:

<telerik:RadGridView x:Name="RadGridView1" ShowGroupPanel="False" CanUserResizeColumns="False"  CanUserFreezeColumns="False" ItemsSource="{Binding Items, Source={StaticResource model}, Mode=OneWay}" IsReadOnly="True" AutoGenerateColumns="false"  DataLoadMode="Asynchronous" IsFilteringAllowed="False" >
           <telerik:RadGridView.Columns>
               <telerik:GridViewDataColumn DataMemberBinding="{Binding ID}" />
               <telerik:GridViewDataColumn DataMemberBinding="{Binding Col2}" />
               <telerik:GridViewDataColumn DataMemberBinding="{Binding Col3}" />
               <telerik:GridViewDataColumn DataMemberBinding="{Binding Col4}" />
               <telerik:GridViewDataColumn DataMemberBinding="{Binding Col5}" />
               <telerik:GridViewDataColumn DataMemberBinding="{Binding Col6}" />
               <telerik:GridViewDataColumn DataMemberBinding="{Binding Col7}" />
           </telerik:RadGridView.Columns>
       </telerik:RadGridView>

and following for the DataGrid:

<DataGrid ItemsSource="{Binding Items, Source={StaticResource model}}" RowHeight="25" CellStyle="{StaticResource Test}" />

[Maya]

Hello Denny,

Will it be possible to remove setting DataLoadMode property and check whether the behavior is the same ?  

All the best,
Maya
the Telerik team

[Denny]

Hello Maya,

without the DataLoadMode it will be even a bit worser.

[Denny]

Hello,

now I made another test:

Result on a Intel Core2 Quad Core 8GB RAM Win7-64bit Machine:
Loadingtime of 50000 Datarows with 8 Columns: 17 miliseconcs.
Binding to a DataGrid: 120 milliseconds. Used Memory: 7 MByte.
Binding to a RadGridView: 4 seconds. Used Memory: 51 MByte.

Result on a Intel i7 Quad Core 8GB RAM Win XP-32bit Machine:
Loadingtime of 50000 Datarows with 8 Columns: 10 miliseconcs.
Binding to a DataGrid: 80 milliseconds. Used Memory: 5 MByte.
Binding to a RadGridView: 5 seconds. Used Memory: 54 MByte.

Result on a Intel i7 Quad Core 8GB RAM Win7-64bit Machine:
Loadingtime of 50000 Datarows with 8 Columns: 10 miliseconcs.
Binding to a DataGrid: 80 milliseconds. Used Memory: 10 MByte.
Binding to a RadGridView: 1 second. Used Memory: 32 MByte.

[Maya]

Hi Denny,

Will it be possible to send us a sample project illustrating the problem so that we could profile it on our side ?
Thank you in advance.  

Kind regards,
Maya
the Telerik team

[Denny]

Hi Maya,

I sent you a Support Ticket, no. 558346.

[Maya]

Hello Denny,

Thank you for the sample. We will investigate it and I will let you know once we have more information about the issue. 

Kind regards,
Maya
the Telerik team

[HAG]

Hi

We are experiencing the same issues.
Is there a solution for this problem?

[Hristo]

Hello,

RadGridView offers a richer set of functionalities and a lot of visual states and this leads to differences in the initial loading. As it turns out we cannot do much in this case.


Regards,
Hristo
the Telerik team

[Uwe]

Hi,
I thought the GridView loads only the data which are in the in the visual field or is it a misunderstanding. In the documentation is mentioned:

The RadGridViewAPI supports UI Virtualization, which processes only information that is loaded in the viewable area, which reduces the memory footprint of the application and speeds up the loading time thus additionally enhancing the UI performance.

Or what dos  processes only information that is loaded in the viewable area mean and where is the different to the performance example in the demo where one milion records are loaded. I think only the source, the SQLServer for example?

Greetings Uwe

[Sergiy]

Hi

I am experiencing the same issues. (in case when i am using simple DataGrid all works perfectly)
Is there a solution for this problem?

[HAG]

Hi,

if you use your gridviews only to display text, you can change the cell style like this:

<Style TargetType="telerik:GridViewCell">
   <Setter Property="Template">
         <Setter.Value>
                <ControlTemplate>
                       <TextBlock Margin="5" Text="{Binding Value, RelativeSource={RelativeSource TemplatedParent}}" />
                </ControlTemplate>
         </Setter.Value>
  </Setter>
</Style>

This gave us a performance boost.

Furthermore we noticed that our grid performance is a lot of faster with the standard theme. If you use something like the windows8 (metro) theme, the grid freezes and will need more time (up to 3 times) to load and display the data. We've already raised a ticket for this problem, So we hopefully get soon a solution or workaround.

[Jc]

Hi,

Any news about this issue?
I'm experiencing the same problem, when displaying very long texts in the radgrid.

Kind regards,
JC

[Maya]

Hi Jean-Christophe,

Could you clarify a bit - do you get degraded performance when you have long text displayed in the cells ? Which version of RadControls are you working with ? Do you set GroupRenderMode to "Flat" as suggested in our documentation ?  

Regards,
Maya
the Telerik team

[Jc]

Yes, when I display long text in the cells, I get degraded performances, very long time for the application to respond.
I use Q1 2013 WPF controls.

[Maya]

Hello Jean-Christophe,

Could you try setting GroupRenderMode property of RadGridView to "Flat" ? Do you get the same performance ?  

Regards,
Maya
the Telerik team

[Jc]

Hello Maya,
It seems to work better now.
Thank you.
KR,
JC