https://v2.silverbullet.md/

This along with a home VPN and you can hit it from anywhere.

Great way to find services you really don’t need to be running.

I mean, this is how you get me to stop buying Kindle books.

I work for a company that handles this In a few ways. We set up read replicas to handle large read queries. To offload the reads from the primary server. Data is replicated to the read replicas so reporting can be run from that server. And not add load to the primary server.

The second approach is sharding. Sharding breaks a large table into smaller, more manageable chunks, distributing them across systems. This reduces the burden on any one server, improves performance, and enables scaling out as data or traffic increases.