Mailing-List: contact general-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: general@lucene.apache.org
Received-SPF: neutral (athena.apache.org: 216.139.236.26 is neither permitted
 nor denied by domain of m.schipperheyn@gmail.com)
Date: Thu, 1 Dec 2011 08:41:40 -0800 (PST)
From: mschipperheyn <m.schipperheyn@gmail.com>
To: general@lucene.apache.org
Message-ID: <1322757700455-3552061.post@n3.nabble.com>
Subject: Security Filtering against large sets of users (think G+ wall)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I'm implementing a Facebook style wall. As with Google+, you're supposed to
see posts by users in your network. The Network is forward-style, meaning
that you can put people in your network while they haven't put you in
theirs.

So, I have two indices: WallPost and User.
user contains an indexed attribute that contains all ids of the users in the
network of the user.

I'm struggling to come up with the best way to query against the WallPost
index.
Let's assume you have 5.000 users with on average 250 users in their
network. 

For every wall query I need:
1. get all the posts of people in user X's network
2. filter out all the post of people where user X is not in their network
(yet)

I could do a query containing a term for each userId in user X's network,
but I'm not entirely sure how to filter out the posts by users who haven't
adopted user X in their network yet, since this information is part of the
User index and not the WallPost index.

It would be easiests if I could do a Filter on the wall post query that
queries the User index to retrieve a list of userIds that have accepted user
X in their network. But I'm not sure if it's possible to query another index
in a filter.

Overall I would love to hear some suggestion on how to approach this best.

Kind regards,
Marc

--
View this message in context: http://lucene.472066.n3.nabble.com/Security-Filtering-against-large-sets-of-users-think-G-wall-tp3552061p3552061.html
Sent from the Lucene - General mailing list archive at Nabble.com.