This is a migrated thread and some comments may be shown as answers.
Data Sources for Kendo Grid
3 Answers 6 Views
This is a migrated thread and some comments may be shown as answers.
Charles
Top achievements
Rank 1
Charles asked on 15 Oct 2018, 08:55 PM

What .Net Objects can be used as  a data source for the Kendo Grid?

Of those objects, are there preferred objects?

Do some types of data source offer better performance than others?  What are they?

We have a grid that will be getting data from comma-delimited files.  Many of these files may contain 100k or more records, so databinding and control rendering

performance must be high/optimal.

3 Answers, 1 is accepted

Sort by
0
Boyan Dimitrov
Telerik team
answered on 17 Oct 2018, 01:50 PM
Hello,

In terms of working with large sets of data I would definitely recommend using server operations in order to work with a relatively small subset of data on the client side. This will guarantee highest performance since the data loaded in the DataSource/Grid are not many. I would suggest to take a look at the: 

   - https://demos.telerik.com/kendo-ui/grid/remote-data-binding demo. ServerPaging, serverSorting and serverFiltering are enabled in order to reduce the data items in the DataSource on the client-side. 

   - Also I would suggest to check the serverPaging, serverSorting and serverFiltering api docs with the examples. 

   - When working with .net object I would suggest working with  IQueryable  collections. 

Regards,
Boyan Dimitrov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Charles
Top achievements
Rank 1
answered on 17 Oct 2018, 01:57 PM

Thanks.  That's helpful.

 

I could use some clarification. You posted:

>>When working with .net object I would suggest working with  IQueryable  collections. 

Does this mean any object that inherits or implements IQueryable is the preferred object to use as a data source? Would this be preferable to JSON?

 

 

 

0
Boyan Dimitrov
Telerik team
answered on 19 Oct 2018, 02:03 PM
Hello,

In general the actual binding of data is performed on the client-side, so basically the Kendo UI Grid is populated with JSON objects either way. My post was an extra help for you when you start implementing the logic on the server. Since you mentioned that the Kendo UI Grid will work with large amount of data I would suggest to use IQueryable to increase the performance to take advantage of executing queries against the data on data base level. 

I would suggest to take a look of the Kendo UI Grid demos for better getting started experience. 

Regards,
Boyan Dimitrov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Grid
Asked by
Charles
Top achievements
Rank 1
Answers by
Boyan Dimitrov
Telerik team
Charles
Top achievements
Rank 1
Share this question
or