[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