Well, I don't know how to transform the existing data from Parent_id-Trees to that left/right-Structure. But I think you are right ... i can't run away from graph theory ;-)
Regards Thomas ------------------------------------------- Thomas Eppler Internet Management Projekte f�r vernetzte Kommunikation, Kollaboration und Projektarbeit im Unternehmen zur F�rderung von Wissensaustausch, situativem Lernen und kollaborativem Arbeiten Postadresse: Grossackerstrasse 65, CH - 8041 Z�rich Email: [EMAIL PROTECTED] Web: http://www.internetmanagement.ch/ -----Urspr�ngliche Nachricht----- Von: Cameron Childress [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. September 2002 19:39 An: SQL Betreff: RE: Trees ... Is there a specific reason you can't use Celko's Nested Set Model? I haven't yet found anything faster or better than that... -Cameron ----------------- Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] > -----Original Message----- > From: Thomas Eppler [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 29, 2002 4:49 AM > To: SQL > Subject: Trees ... > > > Hello alltogether > Does anyone of you have "the best" solution for getting a tree > structure out > of a table by using only one query? > I mean a simple tree structure only using a Parent-ID - and not a tree set > up by using graph theory (e.g. see > http://www.intelligententerprise.com/001020/celko.shtml) > > I still use this CF_tree-Tag, but with bigger amounts of data it gets very > slow. > So what I need is a quick SQL statement which gets me the nodes on level 1 > sorted by data and all the other nodes sorted by ID (so the logical > structure keeps alive). > > Also as I saw in the manual, there seem to be functions within > Transact-SQL > which deal with tree structures ... > > Any hint or idea will be appreciated - also general hints on how to handle > tree structures ... to be honest for years I am looking for > better solutions > .. > > Regards > Thomas > http://www.internetmanagement.ch > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
