What is the Maximum Data I can bind to a TreeList

[Dawit]

I am trying to create a simple treelist. When I bind a data more than 10,000 rows it takes a long time to respond(around 50 sec). If it is more than 50,000 rows it doesn't respond at all. What is the maximum data I can bind to a tree list?

[Angel Petrov]

Hello Dawit,

When binding to a large amount of records you have to optimize the performance. I suggest that you try the following tips to optimize the performance:

1. Using LINQ will significantly improve the performance(shown in this demo for RadGrid but could be applied for RadTreeList as well)
2. You can improve performance by using paging.
3. Turning of the client features.
4. Setting EnableViewState to false.

Keep in mind that the biggest problem is the number of rows itself. I also suggest that you take a look at the following articles(article1,article2) for more tips and tricks about optimization.

Kind regards,
Angel Petrov
the Telerik team

[Florence]

Hello Dawit,

My suggestion is to try the load on demand feature. It decreases load time a lot when having a large data source:

http://demos.telerik.com/aspnet-ajax/treelist/examples/databinding/loadondemand/defaultcs.aspx

[Dawit]

Thank you.
I used load on demand and it seems to optimize the performance for expanding/collapsing one row at a time. But I have another problem, if you want to 'Expand All' , the load on demand gets very slow and you don't want to call your database for each child node in the tree.
Is there a better way to do 'Expand All'/'Collapse All' functionality in RadTreeList with out binding the whole data to the tree?
I was thinking to use Server side paging. Is it possible to use Server side paging RadTreeList? How? I couldn't find VirtualItemCount property.
Ultimately what I want to achieve is to create a RadTreeList and no matter how big the data is, I want to bind only a few number of records(which is most likely to be the pagesize) to the tree and set a VirtualItemCount so it can show the correct number of pages.

Regards,

[Dawit]

I am still waiting for answer please???

[Angel Petrov]

Hello Dawit,

I am sorry to say but with the current implementation of the RadTreeList this could not be achieved. When you use the ExpandAllItems() method all the items of the RadTreeList will be expaned. Additionally you should note that if AllowPaging is set to true, the RadTreeList control renders a pager item (TreeListPagerItem). It is always visible, no matter if the number of expanded items is larger than the page size. Each time a row is expanded/collapsed, the pager refreshes based on the number of expanded items.

Kind regards,
Angel Petrov
the Telerik team