[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