vendredi 19 novembre 2021

How to aggregate data from SQL/MongoDb periodically?

There is a SQL table contains Bids.

When first bids is inserted to table the downcounter starts. After some time, as instance 5 minutes I must aggregate all data and find the max price across bids.

I wonder how to trigger this event and send message to the Node service that should handle this? Another directions when service asks each second DB and compares startDate, endDate and makes aggregate by sum.

Which is approach to choose?

Aucun commentaire:

Enregistrer un commentaire