What is the Maximum Data I can bind to a TreeList

6 posts, 0 answers
  1. Dawit
    Dawit avatar
    5 posts
    Member since:
    Oct 2012

    Posted 25 Oct 2012 Link to this post

    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?
  2. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 27 Oct 2012 Link to this post

    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Florence
    Florence avatar
    6 posts
    Member since:
    May 2010

    Posted 31 Oct 2012 Link to this post

    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
  5. Dawit
    Dawit avatar
    5 posts
    Member since:
    Oct 2012

    Posted 02 Nov 2012 Link to this post

    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,
  6. Dawit
    Dawit avatar
    5 posts
    Member since:
    Oct 2012

    Posted 06 Nov 2012 Link to this post

    I am still waiting for answer please???
  7. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 06 Nov 2012 Link to this post

    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.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017