Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

  • December 7, 2016 at 5:47 pm

    #1916657

    faredoon (12/7/2016)

    I was thinking more along the lines of a "live" app that constantly displays the hierarchical tree nodes and allowing live edits. It's a situation where the reporting is live rather than static and the feedback is more-or-less instantaneous. I will play around with the hybrid approach and see if it works in this case.

    Let us know how it works out either way. BTW... how many nodes in the hierarchy and what are you expecting for an hourly modification rate?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)