Smart UI Components & Libraries – Grid, Scheduler, Gantt, Kanban for Angular, React, Next.js, Vue, Blazor, JavaScript › Forums › Data Grid › Server-side grouping of mass data with virtual scrolling possible?
- This topic has 3 replies, 2 voices, and was last updated 3 years, 5 months ago by
admin.
-
AuthorPosts
-
June 2, 2022 at 3:06 pm #103280
Joey2
ParticipantHello 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
June 3, 2022 at 11:05 am #103282admin
KeymasterHi 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 StoevSmart UI Team
https://www.htmlelements.com/June 3, 2022 at 1:03 pm #103283Joey2
ParticipantThanks for the quick reply and the creation of a work item, Peter.
I have 2 more questions then:
- Is it then possible to display more than 2 groups per page?
- Can the responding records of very large groups also be loaded page by page from the server when expanding the group?
Greetings
Joey
June 3, 2022 at 1:10 pm #103284admin
KeymasterHi 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 StoevSmart UI Team
https://www.htmlelements.com/ -
AuthorPosts
- You must be logged in to reply to this topic.