Load 50k records with dynamic grouping

[Ankit]

Hi,
I am trying to load 50k records on my Kendo UI grid in MVC application, but getting performance issues and sometimes error as well. I also need to provide drag and drop grouping feature with the total of few columns, according to grouping selected.
I also need the multi-select filter with all above functionality, need it to work like a magic too, without taking a lot of time

Your help is much appreciated.

Thanks

[Stefan]

Hello, Ankit,

Regarding the requirements:

1) Having 50k items with grouping and the ability to the fast:

- Option one is to have paging with the server operations. This will only load a certain amount of numbers at once:

https://docs.telerik.com/aspnet-mvc/helpers/grid/configuration#paging

- The second option is to have the endless scrolling feature which will create the feeling that all of the items are on the page and the requests will be made while scrolling:

https://demos.telerik.com/aspnet-mvc/grid/endless-scrolling-remote

https://docs.telerik.com/kendo-ui/controls/data-management/grid/appearance#endless-scrolling

2) MultiSelect filter. The following example is demonstrating how it can be achieved:

https://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/filtering/multiselect-used-for-column-filtering

I hope this is helpful.

Regards,
Stefan
Progress Telerik