Server side paging in TreeList

[Yohannes]

Does TreeList supports server side paging? If not, how to load large data, in ten thousands?

[Nikolay]

Hello Yohannes,

The TreeList supports server paging, however, our server operations service does not support it (ToTreeDataSourceResult method). In other words, if your server is capable of returning the hierarchical data paged, the Treelist will successfully display the returned data. Our ToTreeDataSourceResult method does not support server paging as it internally works with IQueryable. This means that all operations (paging, sorting, filtering) are queries that are executed on the database level. However, to build the hierarchy, you have to fetch all items from the database and then in the memory create the actual hierarchical structure, which means that the paging queries are no longer applicable.

I can suggest significantly improving the TreeList performance by loading the records' children on demand, as shown in the remote binding demo:

• https://demos.telerik.com/kendo-ui/treelist/remote-data-binding

Regards,
Nikolay
Progress Telerik