Favorite List recommendations Cache VS Sessions

[eluser]Otemu[/eluser]
Hi,

Actually just thought of a much better and simpler method to handle the bookmark issue if someone goes bookmark crazy, have a hidden input on the page and just populate the last added favorite time, when a user clicks favorite you can now check this time and decide whether to add favorite or not.

Sometimes it seems tables can't be more optimised and maybe this is the case with your structure, however awhile ago I was using one table for a two level navigation had something like parentid, childid, navname, etc. I had a function that loop though all the top level menus and return all the child's, wasn't heavy at all and at the time seemed sufficient enough. Then I discovered Nested Set model, with one query I could now build this tree with ease, I am not sure if nested set model will help you in this case but if you happen not to know about it great article here.

Good luck with your project