[thelist] Cookie Crumb Navigation Question
Ken Schaefer
ken at adOpenStatic.com
Wed Jul 14 07:56:53 CDT 2004
I don't think I'd do either
Options:
Use a single database table:
ItemID Description ParentID
1 Home NULL
2 SubDir1 1
3 SubDir2 1
Or use an XML file
In either case, use aggressive caching as the underlying data is unlikely to
change often, and you don't want to navigate an XML file, or hit a database,
often.
Cheers
Ken
----- Original Message -----
From: "Rob Smith" <rob.smith at THERMON.com>
Subject: [thelist] Cookie Crumb Navigation Question
: For those of you who've developed cookie crumb navigation before, this
one's
: for you. Would you have one table for the navigation system:
:
: ColID Col1 Col2 Col3 Col4
: -----------------------------------
: 1 Home > Here > There > A
: 2 Home > Here > There > B
: 3 Home > Here > There > C
: 4 Home > Where > No where
: 5 Home > Where > Any where > A
: 6 Home > Where > Any where > B
:
: ... etc ... (where each item is a column)
:
: Or would you implement an RDBMS to manage this task? There are about
400-500
: individual destinations (Home > Where > Any where > A) about about 200
: categories (Home > Where > No where).
:
: main Table
: ==========
:
: ColID Col1
: ----------
: 1 Home
:
: Next Table
: ==========
:
: ColID ParentID Col1
: ----------------------
: 1 1 Here
: 2 1 Where
:
:
: Next Table after That
: =====================
:
: ColID ParentID Col1
: ----------------------
: 1 1 There
:
:
: Next Table after That
: =====================
:
: ColID ParentID Col1
: ----------------------
: 1 1 A
: 2 1 B
: 3 1 C
:
: and on and on and on...
More information about the thelist
mailing list