Prior to upgrading to 7.1 from 6.2 this innerJoin streaming expression returned in ~10 seconds when run from the Solr Admin Console:
innerJoin( search(sial-catalog-material, q="*:*",fl="id_record_spec,display_material_number,display_package_size,display_material_number,display_material_qty,display_formula_weight,display_material_uom,key_brand",sort="id_record_spec asc", qt="/export"), search(sial-catalog-product,defType="edismax",q="7732-18-5", qf="searchmv_cas_number",mm="2<-12%",fl="id_record_spec, id_s,display_en_s_pri_name, display_pno,display_cas_number",sort="id_record_spec asc", qt="/export"), on="id_record_spec" ) After the upgrade it doesn't return at all, or so I thought. I tried running it via curl and it does return after 22 seconds. The search itself returns quite quickly This is the same index, on the same box only after running the index upgrade tool on it. So why the difference in timing? Any configuration suggestions? I am new to streaming, but I have a need for the join. Also it appears that the Admin Console's Stream tool is timing out, is there a way to set the timeout it uses or to have it not timeout? Thanks, -- This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. Click http://www.emdgroup.com/disclaimer to access the German, French, Spanish and Portuguese versions of this disclaimer.