: Solr Join between two indexes taking too long.
Russ,
Do you mean you accelerate only sidecase with small cardinality, or your
problem is resolved in general and 2.3 sec is fine for you?
Regarding longValues. Is it multivalued? It might work if {!join} parser pass
multipleValuesPerDocument=false
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
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
> -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
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
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
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
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
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,
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
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
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\
"\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
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
Hi,
I hope somebody can help.
We have two indexes, one which holds the descriptive data and the other one
which holds lists of docs which are
of a certain type (called universes in our world). They need to be joined
together to show a list of data from indexA
where a filtered indexB (by
15 matches
Mail list logo