Hello,
We have an MVC application using Entity Framework as the interface into our database. We recently added some database logging to our application in order to do some performance analysis. I noticed that in the Read methods for our Kendo grids our SQL seems to be executing twice. Drilling into this a bit more, I found that the Kendo.MVC.Extensions ToDataSourceResult() method against an IQueryable was the place where the double execution was happening. A few of our queries take a fair amount of time to execute, so having them run twice is a performance drag. I was hoping to get some help determining why this might be happening. My best guess is that this is due to paging needing to find out the total row count and then a second execution to get the actual data, but it's only a guess. If your team could help out, I'd really appreciate it. Thanks!
Regards,
Brian
We have an MVC application using Entity Framework as the interface into our database. We recently added some database logging to our application in order to do some performance analysis. I noticed that in the Read methods for our Kendo grids our SQL seems to be executing twice. Drilling into this a bit more, I found that the Kendo.MVC.Extensions ToDataSourceResult() method against an IQueryable was the place where the double execution was happening. A few of our queries take a fair amount of time to execute, so having them run twice is a performance drag. I was hoping to get some help determining why this might be happening. My best guess is that this is due to paging needing to find out the total row count and then a second execution to get the actual data, but it's only a guess. If your team could help out, I'd really appreciate it. Thanks!
Regards,
Brian