I want to implement an advanced search system that has the ability to sort results by their popularity. I feel that update operation is expensive in elastic search. what is the best way to store user likes on my elastic documents.
do I have to increment the likes count each time a user likes a post? or do I have to get results from elastic and sort them based on data in MYSQL database of my app?
by the way my app is implementing the microservice architecture. if you have any idea or blog post about implementing a centralized search service I'll be happy to hear that