Hi Zac, Solr 4.0 (trunk) has support for relationships/JOIN. Have a look: http://search-lucene.com/?q=solr+join
Otis ---- Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch Lucene ecosystem search :: http://search-lucene.com/ ----- Original Message ---- > From: Zac Smith <z...@trinkit.com> > To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> > Sent: Fri, May 13, 2011 12:28:35 PM > Subject: Schema Design Question > > Let's say I have a data model that involves books and bookshelves. I have > tens >of thousands of books and thousands of bookshelves. There is a many-many >relationship between books & bookshelves. All of the books are indexed by >SOLR. > > I need to be able to query SOLR and get all the books for a given bookshelf. > I >see two schema design options here: > > > 1) Each book has a multi-value field that contains a list of all the >bookshelf ID's. Many books will have thousands of bookshelf ID's. In this case > >the query is simple, I just send solr the bookshelf ID. > > 2) I send solr a query with each book on the bookshelf e.g. >q=book_id:(1+OR+2+OR+3 ....). Many bookshelves will have thousands of book >ID's >so the query can get rather large. > > Right now I am using option 2 and it seems to be working fine. I have had to >crank 'maxBooleanClauses' right up but it does seem to be pretty fast. > > Anyone have an opinion? > >
