Hello,
I want to implement
Materialized Path for my org chart table. For example, I'd like to query for all employees that work for a given department, or
any of its sub-divisions.
The Reference Manual barely mentions
Materialized path, under
20. Improving Performance:
Quote:
Batch fetching of collections is particularly useful if you have a nested tree of items, ie. the typical bill-of-materials pattern. (Although a nested set or a materialized path might be a better option for read-mostly trees.)
.
I searched this forum and Google but couldn't find any example of a Materialized Path implementation using Hibernate.
Does anyone have any pointers or a sample to share?
Thanks in advance,
Daniel Serodio