You still need to do a SQL query for each node in the tree. The queries are just hidden inside the stored procedure. This is an excellent solution if you have more writes to the tree than reads.

At the corner of S 6th Street and Park Avenue sits an interesting looking tree. It attracts visitors from all over and is even a stop on the Old Louisville historic ghost tour.In this week's Ask ...

A Germany-based search engine donates nearly 80 percent of its revenues to tree-planting projects around the world. Altogether, nearly three million trees have been planted over the past six years.