Question

[Сергей Кучейко <ri...@gmail.com>]

Hi guys! Maybe you can help me:

I've described problem in this gist
<https://gist.githubusercontent.com/drgrey87/f9efdc1f4fa84a8dabd7ac6de6655f2e/raw/f45004d7d629cde806c990d955dadc42a7b4888e/gistfile1.txt>
.

I tried to use join query parser like this:


http://blabla/solr/LandingInsights/select?defType=edismax&indent=on&q=gdp%20OR%20_query_:{!join%20fromIndex=CEIC%20from=SERIES_ID%20to=series%20v=$qq}&qq=
<http://domain/solr/LandingInsights/select?defType=edismax&indent=on&q=gdp%20OR%20_query_:%7B!join%20fromIndex=CEIC%20from=SERIES_ID%20to=series%20v=$qq%7D&qq=>
 .

 {!edismax%20qf=all_text%20defType=edismax}gdp&qf=insight_attr&wt=json&fl=id&rows=38

         more human readable here <https://prnt.sc/oiyppk> - but this query
so slow (QTime: 7370)

  Also i've looked at streaming expression, but i faced with problem of
JOIN decorators (Both streams must be sorted by the fields being used to
determine equality (the 'on' parameter)).

I think to create new Core that will store LandingInsight's id and
SERIES_ID, may be it will some how help me.

Thanks in advance