I was gonna mention that as well. There's a relevant talk from the System distributed convention https://www.youtube.com/watch?v=QtQMWUik0oY
It's about caching views or queries and updating them when necessary as well as keeping your cache and DB in sync automatically.