[UK-AL]

Either you have fast queries and indexes, or you have a microservice that monitors for certain events, and keeps up to date state in a cache.