If you use oracle the whole id,parentid setup can work ok. If it gets slow you can just generate an xml file for the site to use for menus/sitemap each time an update is done in the admin panel, or if it's really slow, leave it to a manual button push. Personally what I've used in the past is a method of storing a nested structure in a relational database called Nested Sets. Its very cool once you get the hang of it. Don't have my links with me but try googling it. Pretty sure it's been brought up here before too. There used to be a great overview slideshow out there but i can't find it at the moment
Anthony On 10/21/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > I've been racking my brain trying to come up with a feasible solution to a > dynamic site map for a current project. Normally it would be a no-brainer > but this time, the site is HUGE and has nested section after section after > section... > > Once the client receives the final application, they will be adding even > more sections (and undoubtedly subsections). > > I'd like to come up with a way to build the site map dynamically so I (and > eventually they) can just add any new section's title and URL to the > database. > > Without knowing exactly how deep the nests will go, it's proving to be > tough. > > I'm curious to know if anyone else has done something similar with a site > map or a menu or something that dynamically gave the ability to add > unlimited nested items and if so what your database structure looked like. > > Thanks for any ideas. > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.344 / Virus Database: 267.12.4/143 - Release Date: 10/19/2005 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
