Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Efficient Tree data view View modes: 
User avatar
Certified Developer 8
Certified Developer 8
richard - 7/7/2010 7:50:33 PM
   
Efficient Tree data view
Hi there

We have a xml document that we are using for the navigation in a flash movie.

This requires that we get all nodes in the tree and information about those nodes depending on their document type/classname.

We are doing a recursive loop through all of documents to get their document type columns but are finding this very inefficient with the xml taking 15-20 seconds to load if it is not loading from the cache (so whenever the content changes).

Is there a more efficient way of doing this ? I was looking into Hierarchical data but could not really understand how it would fit within the Kentico API.

Any help would be greatly appreciated.

Thanks team


User avatar
Member
Member
Blasty - 7/9/2010 9:41:18 AM
   
RE:Efficient Tree data view
have you setup direct access to the database? Perhaps write a stored procedure that hits the CMS_Tree table and gathers the information for you.

User avatar
Certified Developer 8
Certified Developer 8
richard - 7/13/2010 11:25:41 PM
   
RE:Efficient Tree data view
Thanks Blasty

Yes we ending up doing a big inner join and then used LINQ - went from 15-20 second load to 3 ...

Cheers

Richard