Expanding a large group is slow when EnableLazyLoading and Paging is enabled

[Ben Denham]

Hi,
We are having performance issues with grouping when EnableLazyLoading and Paging is enabled and we try and expand a group which is large. 

Can be replicated here https://blazorplayground.syncfusion.com/VDhIZKhzJViqUIkM

1) Group by ProductName

2) Expand "Gumbär Gummib"

I would expect the performance here to match the performance we would get normally when using paging, however as you'll see from above the performance is not great and the whole UI freezes.

Any ideas on what we can do to address this? 

From profiling the slowness it looks like the expand row functionality is scanning the whole dataset, instead of the paged dataset?

Thanks,
Ben

[Vignesh Natarajan]

Hi Ben,

Greetings from Syncfusion,

We understand that you are experiencing performance issue when expanding a group with Paging and LazyLoad group. We want to inform you that when LazyLoad Grouping is enabled in Grid, once grouping is applied, we will find the group caption details based on unique data and render corresponding records only. Only on expanding, grouping operation will be executed and current page records gets displayed in Grid. Hence the reported query has occurred. This is behavior of the Grid with paging and lazy load grouping. To overcome this, we suggest implementing the infinite scrolling feature instead of Paging. This feature initially renders only the rows that are visible within the viewport and dynamically loads the next set of records as the user scrolls. This approach helps maintain performance by reducing the number of rows that need to be rendered at once, ensuring a smoother user experience even with large datasets. Please refer the attached sample for your reference.

Documentation: Lazy Load Grouping in Blazor DataGrid Component | Syncfusion  - Infinite Scrolling

Refer to the modified sample: https://blazorplayground.syncfusion.com/embed/rZhejAhxIhXTLKuf?appbar=true&editor=true&result=true&errorlist=true&theme=bootstrap5

Please get back to us if you have further queries.

Regards,
Vignesh Natarajan

[Ben Denham]

Hi Vignesh,

Thanks for the update, unfortunately infinite scrolling doesn't work for us due to the limitation, e.g. batch editing.

Is there any other work around here, or a desire your side to resolve the performance issue, as to us the grouping functionality is unusable with this issue.

Thanks,
Ben

[Guhanathan Ramanathan]

Hi Ben Denham,

 

Thanks for the Update,

 

We are currently validating your requirement with high priority and will provide an update within two business days, on or before April 4^th , 2025. Until then, we appreciate your patience.

Regards,

Guhanathan R

[Guhanathan Ramanathan]

Hi Ben Denham,

 

Thanks for the Update,

 

We are currently validating your requirement with high priority and will provide an update within two business days, on or before April 4^th , 2025. Until then, we appreciate your patience.

Regards,

Guhanathan R