You can NOT have a single SQL select to load a tree that is deeper than two levels and has
more than 2 nodes (unless you use a proprietary SQL explode() operator).
Please post again when you have used a profiler and once you have some numbers.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008256#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...