Biggggg Tree Data Structure

[KnNeeded]

Hi,

I have implemented a relational database to store a tree like database (used a method simular to the one found here codeproject (http://www.codeproject.com/asp/hierarchicalsql.asp) ).

We have that with some very large databases with many levels of trees and found a great db performance problem. I was wondering if there are any commercial solutions for database storage that is specifically optimised for tree data structures?

Thanks

KnNeeded.

[eduardo7095]

How about using Joe Celkos approach to building tree structures in SQL "SQL for amarties"

Hope that helps

[dionn]

Have you tried IronGrid's IronEye SQL product? It is a quick and easy way to find out where the performance problems might be...you can get a free trial at www.irongrid.com (http://www.irongrid.com/catalog/product_info.php?products_id=30)

[KnNeeded]

Thanks for the suggestions,

Have tried the trial version and found the problem :).

KnNeeded