Re: join with big 2nd collection

2021-05-05 Thread Joel Bernstein
; got an OOM in some cases. > Will memory requirements change for a single node when adding more nodes > with replicas ? > > Best Regards > Jens > > -Ursprüngliche Nachricht- > Von: Joel Bernstein > Gesendet: Montag, 3. Mai 2021 14:42 > An: users@solr.apache.

Re: join with big 2nd collection

2021-05-03 Thread Joel Bernstein
Here is the jira that describes it: https://issues.apache.org/jira/browse/SOLR-15049 The description and comments don't describe the full impact on performance of this optimization. When you have a large number of join keys the impact of this optimization is massive. Joel Bernstein http://joels

Re: join with big 2nd collection

2021-05-03 Thread Joel Bernstein
If you are using the latest version of Solr there is a new optimized self join which is very fast. To use it you must join in the same core and use the same join field (to and from field must be the same). The optimization should kick in on it's own with the join qparser plugin and will be orders o