Queuing for updating data?

Question

PHP

Something is not built in the head of the algorithm how to do it.
As an example, let's say there is an online game. There is a backend database where everything is stored in a detailed form. I want users to make userbars with some kind of statistics. Accordingly, you don’t want to constantly pull and calculate data from the working database for obvious reasons. To do this, I want to make a separate database and pull data from the combat database into it from time to time. For example this one:

1 Vasya last_update_date last_data_access_date
2 Petya last_update_date last_data_access_date
3 Zhenya last_update_date last_data_access_date

If Vasya's picture competes often enough, then update his data once every 1 hour, and Petya's picture was viewed only once per hour, then update his data once every 3 hours, and if as a result his picture was viewed only once a day, then update it every 6 hours, well, if something changes in the viewer, then update it more often / less often.
What is the best and correct way to organize such database updates for the subsequent generation of images. Articles or examples would be very helpful.

Answer 1

In principle, sphinx will suit you, you can integrate mongo, but it's easier to use sphinx, you can even make a configuration with rt indexes.