Grouping with LinqDataSource

[D]

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

[Antonio Stoilkov]

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:

• Super-charged Performance Optimizations for Telerik's ASP.NET AJAX Grid in Q3 2011

All the best,
Antonio Stoilkov
the Telerik team