I maintain a cache of kinds 3, 1984 and 10000 notes that is updated continuously. I also maintain a graph database with pubkeys as nodes, and each follow and mute forms an edge. (Reports will be next.) Whenever a new kind 3 or 10000 note replaces an old one, the edges of the graph database get updated, individual edges being removed or added as needed.