Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Displaying Sorted Hierarchies (SQL Spackle) RE: Displaying Sorted Hierarchies (SQL Spackle)

  • March 14, 2011 at 4:28 pm

    #1298609

    Michael Meierruth (3/14/2011)

    What sort of hierarchy breaths and depths are people running into in the real world?

    Numbers please!

    Thus for a large telephone company I deal with, I have a table of 300 nodes at 5 levels.

    Each terminal node deals with one or more fairly high level objects such as a company project above a certain cost.

    Of course, starting at each such a node you typically start a new tree with lots of details - typically 50 more nodes at 3 levels.

    But the main tree and sub-trees are dealt with separately.

    And this is where the fun starts.

    So what sort of hierarchies are people dealing with in the real world?

    Is it really zillions of nodes?

    Or is it a couple of hundred most of the time?

    MLM companies can have memberships of millions of nodes several hundred levels deep and very wide fanouts in the dozens or more.

    Other than such monsters, the HeirarchyID will very easily accomodate some very large hierarchies. I can't vouch for the performance yet but the rumor mill on the internet seems to indicate that it's a bit slow.

    --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)