| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Nested Sets vs. Nested Intervals
> > Because when every
> > time I insert a new listing (web page listing, not a node in a tree) in
> > a category, all of the ancestors listings_count row have to be updated.
> > That would be inefficient because the higher the category, the more
> > often listings_count row have to be updated, and it would slow down the
> > directory sufficiently because the hard disk have to rotate to the
> > category_count row frequently so it would slow down other stuff (like
> > selecting categories) considerably. How does dmoz.org do it?
>
> If you ever find out, please post it here:-)
I found out at http://www.skrenta.com/ that dmoz actually uses a flat-file VXFS filesystem Received on Fri Nov 18 2005 - 18:08:33 CST
![]() |
![]() |