Re: Data Model Verification for Hierarchal Data
Quote
I am afraid of the slowness many speak of with the edge lists.
Test them. Be ready for surprises, eg see
http://www.artfulsoftware.com/infotree/treequeryperformance.pdf. The nested sets model has been vastly oversold.
Quote
depth of the hierarchy will remain static.
You may need to test three models: conventional queries with N-1 joins for depth=N, edge list, and nested sets.
PB
Edited 1 time(s). Last edit at 03/25/2011 01:44PM by Peter Brawley.
Subject
Written By
Posted
Re: Data Model Verification for Hierarchal Data
March 25, 2011 09:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.