This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I guess it doesn't take much to figure out the schema, just parent id and all, but how to best query for quick retrieval of all children of a particular node?
Thanks!
James |
|
|
Hi James, There are two common ways of eager loading hierachies: DMBS specific hierachical queries and nested sets. We don't natively support either approach at present but nested sets is on our road map. You may be able to use hierachical queries by using a view to encapsulate the query. Nested sets is also a possibility - you just need to implement the additional columns and query logic yourself. Cheers, Andrew. |
|