RE: A very complex search problem.

2009-09-02 Thread Lie, Birger
HI, I might be unclear in what I mean. Usually people have friends in common, so if you 1) create and store a relationship between user x and y, and give that an id. 2) x knows z than there is a probability that y might know z as well. If that is the case than add z to the relation and you d

RE: A very complex search problem.

2009-09-02 Thread Lie, Birger
Hi, If you store all mutual relations in a database, a lot of the relations will overlap. This is easily done using distinct clauses in sql. Use the overlapped values as tags on documents. That way you gain tremendous performance in search time, Obviously updating documents are a performance los