Radgridview binding to large column set is slow

[Farhan]

I am facing an issue whereby I have 184 columns and I just bind to 10 of those. The rest exist in the background and are not shown on the UI. I have noticed that when I switch from a certain element to another in order to populate the data grid with the respective information of the corresponding element the performance is really slow. I have also fixed the width and height of the data grid, therefore it doesn't seem that there's any issue with respect to the telerik data grid drawing out infinite dimensions. Any insight and suggestions about improving the performance of the radgridview would be really helpful. 

PS: Would it be possible to do a live web session with you guys since if things don't work for us, our clients are getting impatient and we might replace the telerik grid view with the default wpf grid control.

Code Snippet:

<Grid HorizontalAlignment="Stretch">
        <Grid.RowDefinitions>
            <RowDefinition />
        </Grid.RowDefinitions>

        <!--ListBox ItemsSource="{Binding Path=PdsTrancheResults,
            Converter={StaticResource RowTemplateConverter}}"
                 ItemTemplate="{StaticResource RowTemplate}"

                 >

        </ListBox>-->

        <!--<DataGrid ItemsSource="{Binding Path=PdsTrancheResults, Converter={StaticResource RowTemplateConverter}}"
                  AutoGenerateColumns="True"/>-->
        <telerik:RadGridView IsFilteringAllowed="False" Grid.Row="1"
                                     x:Name="ResultOutPutGrid"
                                     HorizontalAlignment="Stretch"
                                     IsReadOnly="True"
                                     ItemsSource="{Binding Path=PdsTrancheResults, IsAsync=True}"
                                     AutoGenerateColumns="False"
                                     AlternationCount="2"
                                     EnableRowVirtualization="True"
                                     EnableColumnVirtualization="True"
                             DataLoadMode="Asynchronous"
                                        MaxWidth="600"
                             MaxHeight="900"
                                     SelectionMode="Extended"
                                     ShowGroupPanel="False"
                                     telerik:StyleManager.Theme="Windows7"

                                     >
            <telerik:RadGridView.Columns>
                <telerik:GridViewDataColumn DataMemberBinding="{Binding Period}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Period" TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding Season}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Seasoning"  TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding Coupon}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Coupon"  TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding Balance}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Balance"  TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding OrigBalance}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Original Balance"  TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding MoodysRating}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Moodys Rating"  TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding AvgOcPct}">
                    <telerik:GridViewDataColumn.Header>
                        <TextBlock Text="Avg Acct Pct"  TextWrapping="Wrap" TextAlignment="Center"/>
                    </telerik:GridViewDataColumn.Header>
                </telerik:GridViewDataColumn>
            </telerik:RadGridView.Columns>

        </telerik:RadGridView>
    </Grid>

[Vlad]

Hi,

 Can you post more info about the grid version? The latest official RadGridView (Q2 2011 SP1) can work in extreme scenarios like this one:
http://demos.telerik.com/silverlight/#GridView/UIVirtualization

The demo is for Silverlight however you can check your local copy of our WPF demos for more info. The grid is even faster in WPF .

Best wishes,
Vlad
the Telerik team

[Farhan]

Hi,

The Telerik Datagrid version we are using is: 2011.2.920.40 .Net 4.0

I can download the latest dlls and try them out. But the fact is the problem is not during scrolling, it is during the loading of the data. I compared it with a simple listbox and the display with the listbox was instantaneous. But when I switched back to the telerik data grid, the same promlem persisted.

Thanks,
Farhan

[Vlad]

Hi,

 Can you compare it to the standard DataGrid instead? 

All the best,
Vlad
the Telerik team

[Nestor]

I see the same problem. It's slow to change the itemssource, especially when there are lots of columns (50+)

[Bahri]

We are experiencing the same issue, where the data returns quickly from the database (only 288 rows), but we load the data into viewmodels, and is bound using the DisplayAttribute.  The data takes forever to load, and when it is finished, the UI is unresponsive.

Did you find a solution?

[Dimitrina]

Hi,

Actually 288 rows are not so much. Do you have the same problem with the MS DataGrid?  May I ask you to test if your UI still freezes using the latest version of the RadControls? 

Regards,
Didie
the Telerik team

[Bahri]

We downloaded the latest controls using the management program.  We switched the grid to the MS DataGrid, and the problem went away, but of course we don't have the features of the RadGridView anymore.

Please help.

[Dimitrina]

Hi,

 Thank you for the update.

Would it be possible for you to isolate the issue in a demo project which we could debug locally? We would be more helpful if we could reproduce the problem.

Greetings,
Didie
the Telerik team