RE: Solr Join between two indexes taking too long.

2015-09-24 Thread Russell Taylor
better using longs I’ll > stick with the strings. > > > Thanks for your help Mikhail and Upayavira now I just need to get the > firm to move to 5.3 ☺ > > Russ. > > > -Original Message- > From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com] > Sent

Re: Solr Join between two indexes taking too long.

2015-09-22 Thread Mikhail Khludnev
> > Thanks for your help Mikhail and Upayavira now I just need to get the firm > to move to 5.3 ☺ > > Russ. > > > -Original Message- > From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com] > Sent: 14 September 2015 15:54 > To: solr-user > Subject: Re: Solr

RE: Solr Join between two indexes taking too long.

2015-09-22 Thread Russell Taylor
-- From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com] Sent: 14 September 2015 15:54 To: solr-user Subject: Re: Solr Join between two indexes taking too long. Why? It's enough to just open index by Solr 5.3 instance. No need to reindex. On Mon, Sep 14, 2015 at 4:57 PM, Russell

Re: Solr Join between two indexes taking too long.

2015-09-14 Thread Mikhail Khludnev
Russ. > > -Original Message- > From: Russell Taylor > Sent: 11 September 2015 14:00 > To: solr-user@lucene.apache.org > Subject: RE: Solr Join between two indexes taking too long. > > It will take a little while to set-up a 5.3 vers

RE: Solr Join between two indexes taking too long.

2015-09-14 Thread Russell Taylor
Looks like I won't be able to test this out on 5.3. Thanks for all your help. Russ. -Original Message- From: Russell Taylor Sent: 11 September 2015 14:00 To: solr-user@lucene.apache.org Subject: RE: Solr Join between two indexes taking too long. It will take a little while to set

RE: Solr Join between two indexes taking too long.

2015-09-11 Thread Russell Taylor
It will take a little while to set-up a 5.3 version, hopefully I'll have some results later next week. From: Mikhail Khludnev [mkhlud...@griddynamics.com] Sent: 11 September 2015 12:59 To: Russell Taylor Subject: Re: Solr Join between two indexes taking too

RE: Solr Join between two indexes taking too long.

2015-09-11 Thread Russell Taylor
I'll try that Thanks Upayavira. From: Upayavira [u...@odoko.co.uk] Sent: 09 September 2015 19:30 To: solr-user@lucene.apache.org Subject: Re: Solr Join between two indexes taking too long. I've never reviewed that join query debug info - very i

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Gopal Patwa
from=longValue to=longValue > > fromIndex=indexB}universe:LARGE", > > "parsedquery": "JoinQuery({!join from=longValue to=longValue > > fromIndex=indexB}universe:LARGE)", > > "parsedquery_toString": "{!join from=longValue to=longValue > > fromIndex=indexB}universe:LAR

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Mikhail Khludnev
;200076769985": "\n1.0 = (MATCH) > org.apache.solr.search.JoinQuery$JoinQueryWeight@7a5d18ac , product > of:\n 1.0 = boost\n 1.0 = queryNorm\n", > "200076769986": "\n1.0 = (MATCH) > org.apache.solr.search.JoinQuery$JoinQueryWeight@6d601adc , pr

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Upayavira
che.solr.search.JoinQuery$JoinQueryWeight@118f9aef , product > of:\n 1.0 = boost\n 1.0 = queryNorm\n", > "200076769985": "\n1.0 = (MATCH) > org.apache.solr.search.JoinQuery$JoinQueryWeight@7a5d18ac , product > of:\n 1.0 = boost\n 1.0

RE: Solr Join between two indexes taking too long.

2015-09-09 Thread Russell Taylor
rg.apache.solr.search.JoinQuery$JoinQueryWeight@6d601adc , product of:\n 1.0 = boost\n 1.0 = queryNorm\n", "200076769987": "\n1.0 = (MATCH) org.apache.solr.search.JoinQuery$JoinQueryWeight@2e262f31 , product of:\n 1.0 = boost\n 1.0 = queryNorm\n", "2

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Upayavira
To explain what a join does: It goes over to the joined index, and executes a query. This results in a list of "ids" that will be used to do a search on the main index. The more of these ids there are, the worse performance will be. Thus, if you have 100k documents that match in the join core, you

RE: Solr Join between two indexes taking too long.

2015-09-09 Thread Russell Taylor
uent changes to the start parameter are fast? Thanks Russ. -Original Message- From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com] Sent: 08 September 2015 23:08 To: solr-user Subject: Re: Solr Join between two indexes taking too long. Hello Russ, It's an inter

Re: Solr Join between two indexes taking too long.

2015-09-08 Thread Mikhail Khludnev
Hello Russ, It's an interesting case! Can you get a brief context? - is it possible to keep both type of data at the same core? Why not? - can you manually shard both indices by those longValues? - It seems like you query a plenty of data, don't you have another query/filter to intersect that join