Brook,
I'd recommend buying SQL for Smarties by Joe Celko. There's a couple of
chapter specifically on ways to handle hierarchy data w/different database
systems. I really like the "Nested-Set Model." The nice thing about the
Nested-Set model is that you can do all your tree parsing/order via SQL-no
need to manipulate the data via CF (which you have to do when simply storing
the parent ID.)
-Dan
-----Original Message-----
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 20, 2000 7:42 PM
To: [EMAIL PROTECTED]
Subject: Database Design Question
I have listings that look like:
1.0 foobars
1.1 foobars the revenge
1.1.2 foobars the revenge II
1.1.2.1 more foobar specials
2.0 brown foobars
3.0 green foobars
etc..
What is the best DB design in terms of performance for a classification
system like this?
Thanks,
Brook Davies
MaracasMedia Inc.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
