Twitter solved this resource problem easily, their closed source client and their single central relay is usually very fast..but it does need a database.😉 

 Hahaha yes! But I think we should have lots and lots of separate databases that update each other over nostr relays.