I have a use case with two possible solutions. I have a collection of companies. I want to store a “score” of numeric value that is specific to each client for each company, and this score changes dynamically via upserts from the database. It is possible (and if so, optimal from a performance perspective) to use nested objects to put the score for each client as a field on the company level, and filter the nested objects by client ID so only the score for that particular client appears, or should I create a separate collection of company, client, and score and conduct a multi-search?

If the number of clients is below hundred, then should be ok to put client scores inside each company record...

Thanks Jason! Great solution with the join feature