I'd like to implement some sort of friendster-like system, where I can see up to 2 levels out (friend of a friend of me). I use SQL7, what is the best schema/process that will handle this the most efficiently? I've looked into tree traversal by cesko, and that sounds like a good idea, but it seems to imply a table that's built with all the relationships in place - but since my buddy might not have anything to do with joe's buddy(i.e. there's hundreds of starting points that might not be connected to anything else) it doesn't seem like a single table would really be efficient. Any thoughts
