Comment
Above in this comment thread:
Trees in SQL: Nested Sets and Materialized Path » ints too small
|
Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today. |
|
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience. Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements? Download Free Report! |
Sponsored by:
Links to external sites are subject to change; DBAzine.com and BMC Software do not control or endorse the content of these external web sites, and are not responsible for their content. LEGAL STATEMENT © 2007 DBAzine.com. All Rights Reserved. |
I was all excited to find this article as I thought it would help me with my large heirarchies - until I saw this post. I did some tests and it seems that the maximum number of elements in the heirarchy cannot exceed 1023 (zero based - using 8 bit numbers). Has anyone come up with a viable solution for this? I would rather not be forced to cap my levels to 20 with no more than 51 elements each. I know that 20x51 is not really efficient in real life applications (or is it?), but I would like the option if I indeed do come across a heirarchy with limits higher than those.