patrick on Nostr: Seems like you need an aggregation event. Clearly, fetching 1M events to see that a ...

Seems like you need an aggregation event. Clearly, fetching 1M events to see that a post has 1M likes or that a key has 1M followers doesn’t scale. Relays (or even ‘aggregate’ relays) could collect kind 3, kind 7, etc. and have a different replaceable event that is the totals for each.
Then showing total likes, followers, etc. is 1 event.
Original kind 3/kind 7’s could have very short window for explicit data - keeping them only 7d for eg.
Could have event w/ bloom filter for good approximation of ‘did I like this’ matching.