RE: Solr Join between two indexes taking too long.

2015-09-24 Thread Russell Taylor
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: 14 September 2015 15:54 &

RE: Solr Join between two indexes taking too long.

2015-09-22 Thread Russell Taylor
udnev [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 Taylor < russell.tay

Re: Solr Join between two indexes taking too long.

2015-09-22 Thread Mikhail Khludnev
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 Join between two in

Re: Solr Join between two indexes taking too long.

2015-09-14 Thread Mikhail Khludnev
> -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 version, hopef

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-up

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 long

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 interesting

RE: Solr Join between two indexes taking too long.

2015-09-09 Thread Russell Taylor
r 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 interesting case! Can you get a bri

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,

RE: Solr Join between two indexes taking too long.

2015-09-09 Thread Russell Taylor
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", "200076769988

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Gopal Patwa
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}un

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Upayavira
Query$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 = queryNorm\

Re: Solr Join between two indexes taking too long.

2015-09-09 Thread Mikhail Khludnev
"\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 , product > of:\n 1.0

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