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?