Storing hierarchy data and retrievethe thte tree fast RRS feed

  • Question

  • I want to store data in a tree format and navigate the tree several times, i tried using cte for navigation it works fine for 100 levels, now i am using Hierarchy id , but the problem i am facing here is it goes only 1427 levels deep. Pls let me know any other efficient way to store and retrieve  hierarchy data which goes 1000's of level deep. This is of urgent need. Kindly respond asap.
    Saturday, May 8, 2010 6:26 PM