Home Forums Article Discussions Article Discussions by Author Discuss content posted by GSquared Hierarchies in SQL RE: Hierarchies in SQL

  • January 28, 2009 at 8:22 am

    #933856

    ventsislav.mladenov (1/28/2009)

    Or you could use CLR store procedures which are very fast in execution and sometimes are faster than T-SQL.

    http://blog.vmladenov.com/?p=197%5B/quote%5D

    Have you speed-tested the queries on that against nested sets hierarchies?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon