Nostr Database strategies:
1. Build indexes for every possible combination of filters: It's fast, but needs a ton (GBs) of memory and 10x your database size in disk. Works great for servers.
2. Don't index all tags: Some filters just won't work and it won't find stuff, but it is fast and memory/disk efficient. Works great for small apps that have known filter needs.
3. Delete events as soon as the app doesn't need them anymore: It's fast and memory/disk efficient, but search sucks and figuring out what can be deleted is a major hassle.
Did I miss anything?
I actually think the goal of private equity is to destroy businesses. And their investors are all those businesses' direct competitors, with a bunch of fools from public markets make it legal. In that way, the competitor can share the cost of bankrupting a rival with the public market while collecting new revenues from those who won't go to the bankrupt place anymore.
Now put that simplistic view 7 c-corps deep and add politicians and sovereign funds to it.