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
0
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
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
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
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
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.