Hi all, I have a data modelling question. A department of ours is indexing companies and including a multivalued field in the doc to store a set of tickers related to the company. Sounded fine at first until I saw one document where the multivalued field had over 50,000 elements in it. There are other documents that are storing even more than this because Solr will hang and won't return the document.
This is a *_ss field, and their query would be an exact match to one of the values in this field to return the company name, eg: ticker_fieldname_ss:"AAA NOE 12/31/21". I'm wondering what would be the best solution to index this data and search for the ticker information on a company? One way I'm thinking of is rather than storing the ticker information as a field on the company, have each ticker its own document with the fieldname of the company. Would love to hear your thoughts on this. Thanks! Regards, Ryan
