I am dynamically loading a tree from the SQL database, using datasets. It loads fine. But, for some of the data, there are about 1000 children. It takes very long to load the treenodes( about 90 seconds). Also, i have provided a search capability to search in the tree. For, large trees, it gave me an error:-

Action Cancelled

On other machine, it gave me more useful error message regarding exceeding some maximum length. Then, I added following code to the web.config file for increasing the size:-

<httpRuntime
    maxRequestLength="8000"
/>

Now, I don't get the error, but it is very-very slow. I just cannot give it to the user. It is so frustrating to sit in front of the machine and give it about 2 minutes after every click.
What can i do to reduce the wait time. I was using one session variable and i removed that also. Please help! It is very urgent, as my deadline is this week. The problem is only for tree with lots of children.
Thanks a lot.

The only option I see is to reduce the amount of data being returned.

Thanks for the reply, but how can i do that , I need to show all the children at one time. I wish I could do it with a list kind of view and load first few records, but they need to see all the children in one go and if they expand further, they have more children under each child.

Is this a 3rd party control you are using?