09-04-15, 04:53 #1Registered User
- Join Date
- Sep 2015
Unanswered: nested set model with multiple tree in multiple tables
i have develop a MLM (multiple level marketing ) system and like use nested set model in hierarchy users.
may tree in MLM over 1.000.000 row. and should have multiple table and each table Separate self nested set model , while connect all trees to one Forest.
With this approach
nested set model run very fast !!!
If you have solution Explain your idea
09-04-15, 07:48 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
Joe Celko did a much better job of explaining the nested sets model than I can, and since Joe frequently visits DBForums he may drop into this thread and contribute.
I'd suggest that you read the appropriate part of his book Joe Celko's Trees and Hierarchies in SQL for Smarties, Second Edition before you ask too many questions. Joe doesn't have much patience with questions from people who want him to custom build them a solution for free, but he's pretty helpful to those who want education.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.