Dynamic Navigation

[eluser]ibnclaudius[/eluser]
Let's say I have a dynamic navigation, with categories and subcategories. Every time a page loads, I have to make some database queries to build it. How can I optimise it?

[eluser]solid9[/eluser]
Are you trying to say how to implement it?
That's really easy.
Just fetch everything from your DB and then store the categories and subcategories into array.
Your array will serve as your array map.

[eluser]PhilTem[/eluser]
http://ellislab.com/codeigniter/user-gui...ching.html

Cache either the database query result or the array created from it or html of the final navigation

[eluser]ibnclaudius[/eluser]
Thanks, database cache will do it.