Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (nike.apache.org: domain of jrbrock@gmail.com designates
 209.85.161.48 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=ft1/c+RkQKCA7vfsAKzXcCcHLo1N99nZEVhzucq0NhQAdFioNyIi9cYtu5XlRCZ037
         9ltS80mtGOaSmE4KM7bS1nh2i8IMGEuj+T9cvNVhZzsY2oo+zOPLJqdf99Lw+FKeB+Oc
         iSvZB2DCcM86em4lIRqBLmHN1fGTGTWtdI/RA=
MIME-Version: 1.0
Date: Wed, 19 Jan 2011 10:19:05 -0500
Message-ID: <AANLkTikVCR_kTG75qr4-iOdH80XdafAZpxvBJqo=U3r4@mail.gmail.com>
Subject: facet or filter based on user's history
From: Jon Brock <jrbrock@gmail.com>
To: solr-user@lucene.apache.org
Content-Type: text/plain; charset=UTF-8

Hi,

I'm looking for ideas on how to make an efficient facet query on a
user's history with respect to the catalog of documents (something
like "Read document already: yes / no"). The catalog is around 100k
titles and there are several thousand users. Of course, each user has
a different history, many having read fewer than 500 titles, but some
heavy users having read perhaps 50k titles.

Performance is not terribly important right now so all I did was bump
up the boolean query limit and put together a big string of document
id's that the user has read. The first query is slow but once it's in
the query cache it's fine. I would like to find a better way of doing
it though.

What type of solr plugin would be best suited to helping in this
situation? I could make a function plugin that provides something like
hasHadBefore() - true/false, but would that be efficient for faceting
and filtering? Another idea is a QParserPlugin that looks for a field
like hasHadBefore:userid and somehow substitutes in the list of docs.
But I'm not sure how a new parser plugin would interact with the
existing parser. Can solr use a parser plugin to only handle one
field, and leave all the other fields to the default parser?

Thanks,
Jon