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

Grouping with LinqDataSource

1 Answer 26 Views
Grid
This is a migrated thread and some comments may be shown as answers.
D
Top achievements
Rank 1
D asked on 25 May 2012, 06:09 PM
I have a RadGrid that's using an Asp.Net LinqDataSource to feed it data. I'm working with a particularly large data set (20k+ records) and the capabilities of the RadGrid to utilize the LinqDataSource's ability to page and sort at the database level have been highly useful. After running Sql Profiler, I've noticed that Grouping is having performance issues due to the fact that it's bringing the entire dataset back to the server and doing the grouping operations there. Is this expected behavior or am I doing something wrong?

Thanks,
Dennis

1 Answer, 1 is accepted

Sort by
0
Antonio Stoilkov
Telerik team
answered on 30 May 2012, 09:15 AM
Hello,

Unfortunately the RadGrid does not support groping performed on the database level via LINQ to SQL. The RadGrid grouping is designed to get all data from the datasource and perform grouping over it. However if you have a millions of records this could slow down the performance. However the good news is that since Q3 2011 release we had a new LINQ based grouping which is turned on by default. This type of grouping has a huge performance optimization and internally uses Dynamic Linq for grouping. Also this grouping is controlled by the MasterTableView.EnableLinqGrouping property(default value is "true"). More information you could find here:

All the best,
Antonio Stoilkov
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
D
Top achievements
Rank 1
Answers by
Antonio Stoilkov
Telerik team
Share this question
or