How can we get accurate numbers out for aggregates applied to a grid with virtual paging enabled?
I've recently switched over a grid to virtual paging. Before, the code would just select everything and let the control work out what to display and how to deal with groups and aggregates. However, many of my customers were running into issues (understandably) with large tables - those containing a few hundred thousand or more. The grid was taking forever to display / group / page / etc.
Now, the grid is very high performance, thanks to the new MSSQL 2012 OFFSET... FETCH NEXT statement - it's about time they implemented that! While it's high performance, i've now lost the ability to do grouping and aggregates correctly. It will only summarize what is on the current page. Certainly that makes sense - there's no way for the telerik grid to read data it hasn't been handed.
So - how do i correct this? I don't need a full-blown example, but rather just a quick push in the right direction. Is there a function i can override to deal with the groups / aggregates manually? Is that the right choice? Any help here would be appreciated!
Thanks!
-RP
I've recently switched over a grid to virtual paging. Before, the code would just select everything and let the control work out what to display and how to deal with groups and aggregates. However, many of my customers were running into issues (understandably) with large tables - those containing a few hundred thousand or more. The grid was taking forever to display / group / page / etc.
Now, the grid is very high performance, thanks to the new MSSQL 2012 OFFSET... FETCH NEXT statement - it's about time they implemented that! While it's high performance, i've now lost the ability to do grouping and aggregates correctly. It will only summarize what is on the current page. Certainly that makes sense - there's no way for the telerik grid to read data it hasn't been handed.
So - how do i correct this? I don't need a full-blown example, but rather just a quick push in the right direction. Is there a function i can override to deal with the groups / aggregates manually? Is that the right choice? Any help here would be appreciated!
Thanks!
-RP