OT and completely beyond the scope

Post #153,412 by drewk 5/2/04 4:05:46 PM Reply	OT and completely beyond the scope You should be using nested set trees for your tree structured data. That's how IWeThey does it, and I've followed the links Scott posted back when he wroted it to implement some stuff recently. === Implicitly condoning stupidity since 2001.
Post #153,454 by ChrisR 5/2/04 10:39:53 PM Reply	Scott's the one that pointed me in the Sybase direction I do use nested set trees in the application. But I also keep parent/child pointers in the table, as some things run faster on one or the other - depending on what you are trying to poll. Nested sets are definitely the shizz. Admin provided me with some sample T-SQL code last year that helped me get over the performance hump in the application. Probably wouldn't have quite my previous job without 'em. :-)
Post #153,466 by drewk 5/3/04 7:30:11 AM Reply	Cool, and a question Probably wouldn't have quite my previous job without 'em. :-) Did you mean "quit" your previous job? Just struck me as odd that the job would have been a "previous" already if you were doing it well. Or was it a contract? Eh, maybe I'm just reading too much into it. === Implicitly condoning stupidity since 2001.
Post #153,489 by ChrisR 5/3/04 10:36:09 AM Reply	Spelling impaired Working outdoors all day putting up the new shed and the brain went to mush. :-)
Post #153,474 by admin 5/3/04 8:34:43 AM Reply	Parent/child IDs zIWT uses them too, because as you noted there are some situations where they are faster. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #153,476 by drewk 5/3/04 8:53:29 AM Reply	When would that be? Other than "What is the immediate parent of this one record" I can't think of one. Off the top of my head I can't think of a reason to want that. Reason I'm asking is that I've written a way to move children to a new parent. I could add the parent/child columns, but won't do it if there's not a compelling reason. === Implicitly condoning stupidity since 2001.
Post #153,478 by admin 5/3/04 9:08:24 AM Reply	That's a big one. But the use isn't necessarily one of querying. Consider the "parent" links on the post view page. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #153,479 by drewk 5/3/04 9:12:48 AM Reply	OK, but why not ... Wait, I think I just answered my own question. I use threaded view instead of one post at a time, so you've already got the data. I guess one-post-at-a-time mode you don't already have that. === Implicitly condoning stupidity since 2001.

Welcome to IWETHEY!