Using grouping and paging with large grids

[Ian]

Is it possible to use the group by function in RadGrid also using the Skip() and Take() linq functions rather than pulling the entire table in every time?  We're currently using a grid that has 40000 rows (and up to 30 columns) and using the Group By functionality takes over 2 mins to complete, causing a timeout. 

Currently when I use GroupBy with Skip and Take, it just groups the entries in that particular view depending how the table is sorted (i.e. just those 50 rows) rather than the correct grouping as it would be over the full 40000 rows.  Is there any way to get this to work correctly?

 

[Ian]

Or if this is not possible, is it possible to pass an already Grouped list to the RadGrid and have it display the same way as it would if you have just used the Drag Column to header functionality?

[Kostadin]

Hello Ian,

I am afraid that you need to pass the entire data in order to group all records of your datasource. Additionally if you add a grouped list of items as a datasource they will be displayed in the order you have pass them but will not display the group header (footer). Generally the grid automatically creates the groups internally and it could not be optimized.

Regards,
Kostadin
Telerik