We all know ToDataSourceResult can be extremely slow with large data sets. A lot of times with comes down to this line:
result.Total = data.Count();
The "solution" has been to change the Kendo MVC source code or implement custom bingding.
I am sorry but this is not an acceptable "solution".
Make this call an extension method that one can override easily in our applications.
Best Regards
http://www.telerik.com/forums/unnecessary-(and-slow!)-sql-request-on-todatasourceresult
http://stackoverflow.com/questions/15843703/kendo-mvc-todatasourceresult-extremly-slow-with-large-iqueryable
https://www.google.no/search?q=kendo+result.Total+%3D+data.Count()%3B&oq=kendo+result.Total+%3D+data.Count()%3B&aqs=chrome..69i57.1071j0j7&sourceid=chrome&ie=UTF-8#q=kendo+ToDataSourceResult+slow