I have more than 400,000 data, ToDatasourceResult take to long.

1 Answer 191 Views
Grid
faris
Top achievements
Rank 1
faris asked on 28 Dec 2022, 05:00 PM
Hye.. I cant use ToDatasourceResult, because its take too long. But if i use normal datacontext, its just take a second to show the data. Please assist me. thank you

1 Answer, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 02 Jan 2023, 10:14 AM

Hello Faris,

 

Thank you for contacting us.

This is a lot of records given that it they also may use operations like Filtering, Sorting, Grouping, etc.

In these situations we highly suggest that you utilize the Virtualization capabilities provided by the Grid:
- https://demos.telerik.com/aspnet-mvc/grid/virtualization-remote-data

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

You can also find some neat ideas here:
https://www.telerik.com/blogs/how-to-get-the-best-grid-performance

But if the issue remains after these options, I recommend that you switch to Custom AJAX Binding as demonstrated in this live sample:
https://demos.telerik.com/aspnet-mvc/grid/customajaxbinding

Let me know what are your thoughts.

 

Regards,
Eyup
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Grid
Asked by
faris
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Share this question
or