Materialized path pattern VS Hierarchyid

Posted by Luke101 on Stack Overflow See other posts from Stack Overflow or by Luke101
Published on 2010-04-22T23:36:56Z Indexed on 2010/04/22 23:43 UTC
Read the original article Hit count: 1101

Filed under:

I am reading the SQL server 2008 bible and it says the materialized path pattern is significantly faster then the hierarchyid. Is this really true? How can I make the hierarchyid have equal or better performance.

Related posts about hierarchyid

How to find ALL descendants using HierarchyID for SQL Server

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to find all descendants of a category using HierarchyID for SQL Server. I know how to find direct childs but I would like to find childs of childs of child..etc. Is there a way to do this using the hierarchyID. >>> More
SqlMetal, Sql Server 2008 database, Table with HierachyID, dal cs file is created sometimes ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 2 databases with a 2 tables with HierachyID fields. For one database I can get a dal cs file, for the other database I cannot get a dal cs file ? HBus is a database I can get the dal cs for, ... SqlMetal /server:.\SQLSERVER2008 /database:HBus /code:HBusDC.cs /views /functions /sprocs /namespace:HBusDC… >>> More
Question about SQL Server HierarchyID depth-first performance

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to implement hierarchyID in a table (dbo.[Message]) containing roughly 50,000 rows (will grow substantially in the future). However it takes 30-40 seconds to retrieve about 25 results. The root node is a filler in order to provide uniqueness, therefor every subsequent row is a child of… >>> More
How to find ALL Ancestors using HierarchyID for SQL Server

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched the internet for an answer to this. I don't want to use recursion using getancestor because I think that defeats the purpose. I am trying to get the lowest ancestor of a child. I am using this for breadcrumbs. Thanks >>> More
Does Linq to SQL or Linq to Entities 4.0 support the hierarchyid datatype

as seen on Stack Overflow - Search for 'Stack Overflow'
Is their a way to use linq to SQL/Entities 4.0 to work with the hierarchy datatype? >>> More

Developer IT

Materialized path pattern VS Hierarchyid - Developer IT

Materialized path pattern VS Hierarchyid

materialized-path-pattern

hierarchyid

sql-server-2008

c#4.0

Related posts about materialized-path-pattern

Materialized path pattern VS Hierarchyid

Sorting tree with a materialized path?

Related posts about hierarchyid

How to find ALL descendants using HierarchyID for SQL Server

SqlMetal, Sql Server 2008 database, Table with HierachyID, dal cs file is created sometimes ?

Question about SQL Server HierarchyID depth-first performance

How to find ALL Ancestors using HierarchyID for SQL Server

Does Linq to SQL or Linq to Entities 4.0 support the hierarchyid datatype

Categories cloud