[thelist] Cookie Crumb Navigation Question
Rob Smith
rob.smith at THERMON.com
Tue Jul 13 12:52:13 CDT 2004
Hi
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...
Basically it's the differene between a linear search and a binary search.
Thanks!
Rob Smith
More information about the thelist
mailing list