In Solr 5.1.0 we had to flatten out two collections into one Item - about 1.5 million items with primary key - ItemId (this mainly contains item description)
FacilityItem - about 10,000 facilities - primary key - FacilityItemId (pricing information for each facility) - ItemId points to Item We are currently using this index for only about 200 facilities. We are using edismax parser to query and boost results I am hoping that in Solr 6 with Parallel SQL or stream innerJoin we can use two collections so that it will be helpful in doing updates. But so far I have not seen something that will exactly fit what we need. Any thoughts/suggestions on what documentation to read or any samples on how to approach what we are trying to achieve? Thanks
