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

[Guhanathan Ramanathan]

Hi Ben Denham,

Thanks for your patience.

We appreciate your suggestion and have thoroughly reviewed it at the source level. While your approach improves performance by loading only the records for the current page, we encountered challenges when navigating to the second page to load the next set of grouped records.

Resolving this issue would require significant structural changes, and enabling additional features would introduce new scenarios that need careful evaluation. We also need to verify whether this approach causes any issues in various cases. Given these complexities, we consider this a feature rather than a bug.

As a result, we have classified your request as an improvement and logged a task titled "Improve the performance of lazy load grouping with paging." During the planning stage of each release cycle, we review all open feature requests and prioritize them based on parameters such as product vision, technological feasibility, and customer interest. This improvement is scheduled to be included in our Volume 3, 2025 main release.

You can track the status of your request, review the proposed resolution timeline, and contact us for further inquiries through below link

https://www.syncfusion.com/feedback/66748/improve-the-perfomance-of-lazyload-grouping-with-paging

 

You can reach out to us anytime regarding this open feature using the feedback report page mentioned above. Currently, we do not have immediate plans to implement this feature, but it may be included in one of our future releases. Please cast your vote to help us prioritize this improvement in upcoming releases based on demand. For now, we are closing this ticket. However, you can always communicate with us about open features through the Feature Report page.

Regards,

Guhanathan