All, We are attempting to convert a fairly large relational database into Solr index(es).
There are ~100,000 products with ~1,000,000 accessories that can be related to any number of the products. So if I include the search terms and the relationships in the same index, we're looking at a pretty huge index. If we break it out into three indexes, one for the product search, one for the accessories search, and one for their relationship, is there a good way to merge the results? Is there a better way to structure the indexes? We will have a relational database available if it makes sense to do some sort of a hybrid approach. many thanks, Jonathan
