Hey everybody, I just wanted to get a discussion going on nested sets. In the past few weeks, I had to work alot with the ofbiz category structure and I really got the feeling that the way the productcategories are setup, it takes an awful lot of time to run through the categories, slowly querying from level to level and work your way down to the data you need. I got the feeling that we could really improve the data structure behind that by introducing nested trees. I have done a similar thing for a non-ofbiz-based application and the query results are really fast that way (the queries themselves are rather simple to put together to).
In case you need some additional information on this topic: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html (just scroll down to nested sets). On a different note, I also noticed that the macro within sidedeepcategory.ftl is awfully complicated, possibly much more complicated than it has to be and I'd be interested in approving the very same. I couldn't get my head around the contentWrapper class, but I think that calling the .getRelated function, could do the trick also and possibly be a simpler solution... any thoughts`? -- View this message in context: http://www.nabble.com/Implemantation-of-nested-trees-for-productCategories-tp21497618p21497618.html Sent from the OFBiz - Dev mailing list archive at Nabble.com.
