platformOS Community

What's the best practice for aggregating data?

Adam Cook May 10 2021 at 15:34

On a marketplace, we need to maintain a list of each country, state, city and district that is represented on the marketplace listings.

I know it wouldn't be practical to aggregate this data from a query of the listings every time we need it. And as the number of records increase, it will become even less practical.

So, do I just create a table for the aggregate data and then update it every time a listing is updated?

Please sign in or fill up your profile to answer a question