Very Low performance of kendo grid while loading the data

[Prasanth]

Hi experts,
We are significantly experiencing the performance issue while loading the data with kendo grid. We are using linq to entities to interact database and it is generating query. After that we are applying "query.AsNoTracking().ToPagedList(criteria.CurrentPage);" here it takes along time to  load as it has almost 400k+ records and it is displaying 20 in the grid as page size is 20. For displaying first 20 records from 400k records it is taking 2 min, for the next 20 records again it is following same process which is far acceptable. We are doing union of two queries and 8 to 10 joins in each linq query. Could anyone suggest how to improve performance of this query. Please respond as soon as possible............thanks in advance

[Dimitrina]

Hi,

I can suggest you to check the following discussions in the Kendo UI forums:
Seriously slow Grid performance
Grid Performance issues with 4000~ rows and 26 Collumns
Kendo Grid Performance while doing the Read Request (Filtering, Sorting, Grouping)
 
Regards,
Dimitrina
Telerik