Pre-calculate it.

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #169,179 by admin 8/13/04 11:48:12 AM Reply	Pre-calculate it. I do that in the stored proc that inserts the new nodes by adding one to the level of the parent node. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #169,192 by ChrisR 8/13/04 12:41:34 PM Reply	That's a better way to do it. Unfortunately, the tree I'm dealing with can take different shapes at run time, based on access rights and another tree that gets blended in.
Post #169,293 by deSitter 8/14/04 3:52:19 AM Reply	Re: Pre-calculate it. That's interesting, it's differentiation. -drl

Hierarchical SQL - (ChrisR) - (4) - Aug. 13, 2004, 11:13:17 AM EDT

Pre-calculate it. - (admin) - (2) - Aug. 13, 2004, 11:48:12 AM EDT

That's a better way to do it. - (ChrisR) - Aug. 13, 2004, 12:41:34 PM EDT

Re: Pre-calculate it. - (deSitter) - Aug. 14, 2004, 03:52:19 AM EDT

Those are different nested sets. - (admin) - Aug. 13, 2004, 03:30:18 PM EDT

Holy cran.
90 ms