Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2015
    Posts
    1

    Unanswered: nested set model with multiple tree in multiple tables

    hi.

    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


    very thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •