Performance Tree View Listbox

[amien]

!I created a hierarchy load which results in about 600.000 records and 4 node levels.

when i create the listbox with treeview it takes about 30 seconds to create it. When its rendered the performance itself is very good.

Also when the enduser switches to another sheet, rendering the treeview also takes very long (not workable).

Anyone also had performance issues with the treeview? What can i do to optimize? (sorry can't share the qvw)

[MarcoWedel]

Did you use a path field or create the path in a list box expression?

Regards

Marco

[amien]

I used this:

Hierarchy(NodeID, ParentID, NodeName,,NodeName, HierarchyPath, '|', [Depth])

And then a listbox with treeview enabled with HierarchyPath as dimension and no expression.

[amien]

I added an example in the first post (Thanks Sander)