Re: Slow cross-core joins

2015-03-03 Thread Mikhail Khludnev
Excuse me for hijacking: I raised https://issues.apache.org/jira/browse/LUCENE-6332. Please vote if you need. On Mon, Mar 2, 2015 at 11:04 PM, Matt B wrote: > I've recently inherited a Solr instance that is required to perform > numerous joins between two cores, usually as filter queries, simila

Re: Slow cross-core joins

2015-03-03 Thread Matt B
Thanks all for the suggestions. Regarding patch SOLR-4787, it seems like this will only work with long or int fields and not strings like email addresses. But my coworker suggested the possibility of using a hash to generate long fields from the string fields, so I may try that out. -Matt

Re: Slow cross-core joins

2015-03-03 Thread Mikhail Khludnev
On Mon, Mar 2, 2015 at 11:04 PM, Matt B wrote: > There may be anywhere from one to one million documents in the lists core > matching any particular list_id. Matt, What about reverse cardinality of this relation? ie for particular listValue term, how many list_ids are associated? it's can be f

Re: Slow cross-core joins

2015-03-02 Thread William Bell
I agree that join is slow. Adding fq on LocalParams is good. Has this been added to {!lucene} and other calls like join ? On Mon, Mar 2, 2015 at 2:00 PM, Gopal Patwa wrote: > You could give a try for this join contrib patch > > https://issues.apache.org/jira/browse/SOLR-4787 > > > > On Mon, Ma

Re: Slow cross-core joins

2015-03-02 Thread Gopal Patwa
You could give a try for this join contrib patch https://issues.apache.org/jira/browse/SOLR-4787 On Mon, Mar 2, 2015 at 12:04 PM, Matt B wrote: > I've recently inherited a Solr instance that is required to perform > numerous joins between two cores, usually as filter queries, similar to the >