I have 2 Indices (markets and traders).
Now here trader have their own indices and market have their own. And now here trader can trade at multiple markets.
Now suppose if anyone search by market name then I will show that market in search result page, but now at the same time I also want to show traders who trade at that market. So how can I do it?
I have a solution that while saving record of traders to Algolia, also I push markets in that record to which trader trader at. But in this case, what to do when market details get update on site? As at that time updating trader details will be costly operation and there will be many such traders. So any solution ?
Please help me. Thanks.