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

[faris]

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

[Eyup]

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