[Grid] Grouping on a column with aggregates and many unique groups freezes the page

[vtachkov]

Description

When working on a grid with many rows (10k+), grouping on a column with many distinct values with aggregates enabled freezes the page while kendo is internally processing the data.

Additionally, we have a very similar legacy page in our application that was built with AngularJS and the jQuery version of Kendo-UI, with near identical grouping and aggregating functionality. The page performance is within expectations on the AngularJS page, but awful on the Angular page, so I see no reason why the performance of the Angular grid can't match that of its predecessor.

Steps to Reproduce

1. Grid with 10k+ rows and at least one column with unique values (like an ID)
2. Grouping enabled
3. Aggregation enabled
4. Group on the ID column
   https://stackblitz.com/edit/angular-hsdpzw?file=src%2Fapp%2Fapp.component.ts

Screenshot or video

Screen.Recording.2024-11-15.at.3.12.51.PM.mov

Actual Behavior

The page freezes while the grouping is in progress

Expected Behavior

Grouping should be relatively quick regardless of how much data is being processed