RE: Many fields versus join

2012-08-21 Thread Steven Livingstone Pérez
: Tue, 21 Aug 2012 06:17:11 -0600 > Subject: Re: Many fields versus join > From: erickerick...@gmail.com > To: solr-user@lucene.apache.org > > Steven: > > Nope, I don't have any benchmarks off the top of my head. > > You could probably compare this pretty quic

Re: Many fields versus join

2012-08-21 Thread Erick Erickson
given some things i read i suspect there > are things to watch out for when defining so many fields (but then, not sure > it 300 is a *big* number). > thanks,steven > >> Date: Mon, 20 Aug 2012 19:28:57 -0600 >> Subject: Re: Many fields versus join >> From: erickerick...@g

RE: Many fields versus join

2012-08-21 Thread Steven Livingstone Pérez
elds) but given some things i read i suspect there are things to watch out for when defining so many fields (but then, not sure it 300 is a *big* number). thanks,steven > Date: Mon, 20 Aug 2012 19:28:57 -0600 > Subject: Re: Many fields versus join > From: erickerick...@gmail.com > To:

Re: Many fields versus join

2012-08-20 Thread Erick Erickson
Join works best with a small number of unique values. Unfortunately, people often want to join on , which is by definition unique per document. The usual advice is to first try to flatten your data as much as possible. There's also some ongoing work on "block joins" that you may want to look at th