We are using Solr 8.9.0. We have configured Solr cloud like 2 shards and each shard has one replica. We have used 5 zoo keepers for Solr cloud.
We want to join with 3 collection in multi shards environment. I think solr is not supported join in multi shards environment. We are trying to use stream expression query instead of solr search query and trying to load data from 2-3 collections to improve update index performance for heavy data. We are able to make stream query and found that its mostly works similar to search query and we also did load test execution to check its performance. Here we found that its almost same performing as search query for 75 lakhs records (we compared actual query vs divide query into stream) We are trying to compare the performance of both query but didn't find any details where its been mentioned that its good to use stream for heavy data As per below thread , for heavy data stream performs good compare to search query. https://stackoverflow.com/questions/41042451/solr-streaming-vs-search Can you please suggest us streaming exprerssion is really useful for large amount of data? Regards, Vishal
