Defer execution of functions in RadGridView Aggregate Result

[Sintayehu]

I have a grid that has more that 100K records. I noticed that the custom functions in the Aggregate Results execute when filtering, sorting, reordering, etc ... 

This as you can imagine slows the grid.

Is there a way to defer execution of this functions? Example DeferToAfterFiltering?

[Dimitrina]

Hi,

I am afraid it is not possible to suspend the update of the aggregate results. Once a CollectionChanged notification is raised and such will be raised when filtering, sorting, etc, all the data results will be updated.

Regards,
Dimitrina
Telerik

 

 

[Sintayehu]

Well this is an issue. subscribing to a collection change is fine and dandy but calculating summary before rows are rendred is just not cool.

I am not sure if you guys tested this but collection changed doesnt mean rows rendering is complete.

I suggest you guys have an event for row rendering done. (And no not DataLoaded).
Also an option for the summaries to be calculated after filtering and row rendered would be great.

[Yoan]

Hello,

Indeed we do not have a out-of-the-box solution for your problem. However, here is something you can try - you can clear the aggregates results in GridView's Sorting/Filtering event. Then on Sorted/Filtered you can recalculate the by using GridView's CalculateAggregates method.

Regards,
Yoan
Telerik