MrNorth
May 21st, 2007, 04:13 PM
Hi!
Im working on a page which displays configurations to the user. The configurations are in a hierarchy, and can be of several diffrent types.
My problem is that there are soo many items on some nodes, like 10 levels or something.
Right now when only using a partially loaded db it takes about 6 seconds for the page to load. But when I load the full db I calculated about 30 seconds. I have used .net caching for the datasets, and the populating methods have been optimized. What I need is to reduce the size of the datasets that are returned. I tried datareaders, but didnt notice any performance gains. It was infact better to use datasets and caching, since items can then be reused when populating the tree.
Anyone have any clever ideas on how to maximize performance for the treeview? I can only think about dynamically loaded nodes.. but have no clue how to implement them.... In order to render the (+) there have to be child items on the node... and if I know that, then I have fetched the child items already.... and then whats the point? Lol.. its driving me nuts!!
/henrik
Im working on a page which displays configurations to the user. The configurations are in a hierarchy, and can be of several diffrent types.
My problem is that there are soo many items on some nodes, like 10 levels or something.
Right now when only using a partially loaded db it takes about 6 seconds for the page to load. But when I load the full db I calculated about 30 seconds. I have used .net caching for the datasets, and the populating methods have been optimized. What I need is to reduce the size of the datasets that are returned. I tried datareaders, but didnt notice any performance gains. It was infact better to use datasets and caching, since items can then be reused when populating the tree.
Anyone have any clever ideas on how to maximize performance for the treeview? I can only think about dynamically loaded nodes.. but have no clue how to implement them.... In order to render the (+) there have to be child items on the node... and if I know that, then I have fetched the child items already.... and then whats the point? Lol.. its driving me nuts!!
/henrik