Hello
I have a page in which I return about 500+ records and the Grid takes about 15 secs to load. Everything up-to the point where I get data from the DB is really fast (less than a sec), but when the data is returned from the controller "Json(vm.ToDataSourceResult(request))" to the time it takes to render the data is really slow. The grid uses Ajax Binding and has default Grouping by 3 columns, and some sorting (See GridDefaults.PNG). To overcome the slowness I tried using Virtual Scrolling (which is fast as it has virtual paging), but this correctly loads the grouped data for the first loaded page (say 100 records) (See Capture.PNG) but on scrolling, the rest of the pages does not have the sub data (See Capture1.PNG), and is broken.
Why is the rending this slow (for the first scenario), Can you please let me know if that is the default behavior and if there's something I can implement to make this faster?
Is virtual scrolling supported with Grouping, as this works for the default first load, but on scrolling, it does get data to render, but is broken on expanding the Grouped columns.
Thanks.
I have a page in which I return about 500+ records and the Grid takes about 15 secs to load. Everything up-to the point where I get data from the DB is really fast (less than a sec), but when the data is returned from the controller "Json(vm.ToDataSourceResult(request))" to the time it takes to render the data is really slow. The grid uses Ajax Binding and has default Grouping by 3 columns, and some sorting (See GridDefaults.PNG). To overcome the slowness I tried using Virtual Scrolling (which is fast as it has virtual paging), but this correctly loads the grouped data for the first loaded page (say 100 records) (See Capture.PNG) but on scrolling, the rest of the pages does not have the sub data (See Capture1.PNG), and is broken.
Why is the rending this slow (for the first scenario), Can you please let me know if that is the default behavior and if there's something I can implement to make this faster?
Is virtual scrolling supported with Grouping, as this works for the default first load, but on scrolling, it does get data to render, but is broken on expanding the Grouped columns.
Thanks.
1 Answer, 1 is accepted
0
Hello,
Virtual scrolling has certain limitations mentioned in the documentation, one of which is the lack of support for grouping. I am really not sure why it takes so much time to render the Grid once the data is retrieved from the server. Indeed, 15 seconds sounds like too much for ~500 records, however the provided screenshots do not provide enough information that we can analyze. You can make sure that it is indeed the Grid rendering that takes so long by starting a timer in the DataSource's RequestEnd event handler, then stopping in once the Grid's DataBound event is triggered. Sharing more code snippets and network logs, or ideally - a runnable sample project would help us investigate further. Feel free to open a support ticket if there is information that you do not wish to be on the public forums.
Regards,
Alexander Popov
Telerik
Virtual scrolling has certain limitations mentioned in the documentation, one of which is the lack of support for grouping. I am really not sure why it takes so much time to render the Grid once the data is retrieved from the server. Indeed, 15 seconds sounds like too much for ~500 records, however the provided screenshots do not provide enough information that we can analyze. You can make sure that it is indeed the Grid rendering that takes so long by starting a timer in the DataSource's RequestEnd event handler, then stopping in once the Grid's DataBound event is triggered. Sharing more code snippets and network logs, or ideally - a runnable sample project would help us investigate further. Feel free to open a support ticket if there is information that you do not wish to be on the public forums.
Regards,
Alexander Popov
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!