even though it technically updates in real time, as new events immediately get written to the DB and then fetched on the next view…

Exactly. It’s a problem with the efficiency of the cache. The idea of a cache, indexer, etc is great. Just need more competition to drive the quality of it. @miljan is right that they shouldn’t be the ONLY one putting in the effort here. Caches are great because they improve reliability and speed. Damus has a whole host of entirely different problems.