lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Otis Gospodnetic <otis_gospodne...@yahoo.com>
Subject Re: Schema Design Question
Date Fri, 13 May 2011 17:36:49 GMT
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 <zac@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?
> 
> 

Mime
View raw message