I want to use elasticsearch in our company. The usage is as following:
We have million of influencers and each influencers have 1000s of posts just like instagram. I have 2 use cases:
- Search among these posts and get the influencers for those posts
- Search among this influencers on basis of their name and other fields.
What would be the best design for elasticsearch. I have 3 options in mind, need to choose 1.
- Create separate indexes for posts and influencer
- Create posts index and keep influencers as nested in those posts. (In this case, we need to update influencer data whenever some metric of influencer is changed)
- Create influencer index and keep posts as nested in the same document.
Please help me out which would give optimum results. Or any other design which may complete my usecase.