Server-side grouping of mass data with virtual scrolling possible?

[Joey2]

Hello support team,

does the server side grouping also work with virtual scrolling?

Also, it seems that when expanding then all records that belong to the group are loaded. However, we have a table with > 100,000 records and 5 categories. When we expand a category, it blows up the frame or grid if thousands records of the same category are then loaded from the server database and sent via JSON.

The two features (virtual scrolling and partial reloading of expanded groups) are quite important to us, so the purchase decision depends on them.

Have I just not found the right approach yet, or can’t the grid do that. And if the latter is true, is something like this planned in the near future?

Thank you and many greetings!

Joey

[admin]

Hi Joey,

Thank you for evaluating our Grid component. At present, it is not possible to combine grouping & virtual scroll. I will create a work item for this missing functionality and we will implement it in a future version. It is currently possible to use either virtual scroll or load on demand independently.

Best regards,
Peter Stoev

Smart UI Team
https://www.htmlelements.com/

[Joey2]

Thanks for the quick reply and the creation of a work item, Peter.

I have 2 more questions then:

1. Is it then possible to display more than 2 groups per page?
2. Can the responding records of very large groups also be loaded page by page from the server when expanding the group?

Greetings

Joey

 

[admin]

Hi Joey2,

We have a property called ‘pageHierarchySize’, which is part of the ‘paging’ property which determines that. That property is still in development mode, but you can experiment with it. It should not be a problem to load thousands of records with paging and grouping enabled and groups loaded on demand like in https://www.htmlelements.com/demos/grid/server-side-grouping/.

Hope this helps.

Best regards,
Peter Stoev

Smart UI Team
https://www.htmlelements.com/

[Author]

Posts