This is a migrated thread and some comments may be shown as answers.

Radgridview binding to large column set is slow

8 Answers 148 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Farhan
Top achievements
Rank 1
Farhan asked on 07 Oct 2011, 01:18 AM
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>

8 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 07 Oct 2011, 06:47 AM
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

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Farhan
Top achievements
Rank 1
answered on 07 Oct 2011, 06:14 PM
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
0
Vlad
Telerik team
answered on 10 Oct 2011, 07:11 AM
Hi,

 Can you compare it to the standard DataGrid instead? 

All the best,
Vlad
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Nestor
Top achievements
Rank 1
answered on 14 May 2012, 03:52 AM
I see the same problem. It's slow to change the itemssource, especially when there are lots of columns (50+)
0
Bahri
Top achievements
Rank 1
answered on 13 Jul 2012, 03:13 PM
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?

0
Dimitrina
Telerik team
answered on 18 Jul 2012, 11:25 AM
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

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Bahri
Top achievements
Rank 1
answered on 18 Jul 2012, 03:24 PM
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.

0
Dimitrina
Telerik team
answered on 20 Jul 2012, 02:08 PM
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

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Tags
GridView
Asked by
Farhan
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Farhan
Top achievements
Rank 1
Nestor
Top achievements
Rank 1
Bahri
Top achievements
Rank 1
Dimitrina
Telerik team
Share this question
or