Re: Nested set model with large gaps and spreads in the numbering

>> ... how can you choose when you should perform the compacting? I'm
thinking of a threaded newsgroup application, one that's very, very busy (lots of posts).<<

Well, I start with a DECIMAL (38,0) -- the Oracle max -- for the (lft,rgt) numbering and steps of 100 per level -- and prayer. Very few threads go pass 500 messages. Most of the additions are made on the end of the last post. So a reorg woudl be a once every few months task.

I wish I had a magic answer of eternal expansion within the bounds of finite storage. Received on Tue Sep 24 2002 - 02:18:32 CEST