Keep users in found set?

This is the relationship I have. It really works well I can have unlimited Topics for a piece of Information. Meaning Subtopic for Topics and so on. I have created a couple scripts that can deduce what I am calling the family. What I mean by family is all the members under the Information, every Topic and its Subtopics no matter how deep. So now with this list, could it become something I could receive benefit from storing in another table? My intuition says definitely, but I just want to be sure this is the way to go. I really would like to have a way to keep users in “subject-matter” only the Information and its Topics and Subtopic. Is there a way to keep users locked in a found set only or is this done via Interface design.

Chris Johnston


Back to questions