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

[Solved] Grouping by more than three column makes the application unresponsive

1 Answer 67 Views

GridView

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

This question is locked. New answers and comments are not allowed.

Vijay Srinivasan asked on 27 Oct 2009, 12:32 PM

Hi,

We are using "RadControls for Silverlight Q2 2009" to display results in radgridview. The number of records loaded into the grid range between 600 to 20,000.

When we try to group by more than three columns, entire application becomes unresponsive and we had to close the IE using the task manager.
This is how we have defined the gridview.

    
            <TelerikGridControls:RadGridView   
        
                        IsFilteringAllowed="True" 
        
                        CanUserSortColumns="True" 
        
                        ShowGroupFooters="False"   
        
                        ScrollMode="Deferred"   
        
                        IsReadOnly="True"   
        
                        RowIndicatorVisibility="Collapsed"   
        
                        AutoGenerateColumns="False"    
        
                        ColumnsWidthMode="Auto"   
        
                        CanUserFreezeColumns="False" 
        
                        TelerikControls:StyleManager.Theme="Office_Silver" 
        
                        ExpandableRowStyle="{StaticResource GridViewExpandableRowStyle}">

The rows are expandable and when expanded they show the same data as in the columns. On dataload, we get the record count and display it. On row load, if the row is header row we add a context menu to it(as in the demo).

We are able to see the same behavior in the online demo showing million records. When we tried to group by more than three columns the application went unresponsive. How do we fix this?

Vijay S

1 Answer, 1 is accepted

answered on 27 Oct 2009, 02:30 PM

Hello Vijay,

I've made significant improvement for our upcoming Q3 release and you can check the grid behavior on the same demo with our latest Q3 beta 2 binaries:
http://demos.telerik.com/silverlight/beta/#GridView/Performance

Still grouping on three levels with lots of data can be time consuming especially if you have millions of records - can take more than ten seconds depending on data, column types, etc.

Sincerely yours,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.