This is a migrated thread and some comments may be shown as answers.

What is the Maximum Data I can bind to a TreeList

5 Answers 256 Views
TreeList
This is a migrated thread and some comments may be shown as answers.
Dawit
Top achievements
Rank 1
Dawit asked on 25 Oct 2012, 03:16 PM
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?

5 Answers, 1 is accepted

Sort by
0
Angel Petrov
Telerik team
answered on 27 Oct 2012, 02:39 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Florence
Top achievements
Rank 1
answered on 31 Oct 2012, 03:11 PM
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
0
Dawit
Top achievements
Rank 1
answered on 02 Nov 2012, 10:10 PM
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,
0
Dawit
Top achievements
Rank 1
answered on 06 Nov 2012, 03:58 PM
I am still waiting for answer please???
0
Angel Petrov
Telerik team
answered on 06 Nov 2012, 05:34 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
TreeList
Asked by
Dawit
Top achievements
Rank 1
Answers by
Angel Petrov
Telerik team
Florence
Top achievements
Rank 1
Dawit
Top achievements
Rank 1
Share this question
or