scalibility of Hierarchical Qeries

From: Oxnard Montalvo <>
Date: Thu, 7 Feb 2008 9:01:39 -0500
Message-ID: <3488308.719021202392899359.JavaMail.root@cdptpa-web12-z02>


We are considering the use of a hierarchy to maintain a history of changes to rows in a table.

If the table gets large (1x10^7) and has (1x10^6) different hierachies (10 changes to the same table) I am wondering how it will scale, and any tips to help it scale.


Received on Thu Feb 07 2008 - 08:01:39 CST

Original text of this message