General criteria for performance tuning
In a word: add one more layer, it will be fine.
For example:
1. Add a middle layer to isolate the database and client, which can improve the overall throughput and performance.
two。 Add a layer of cache to cache the query results without actually executing physical queries to improve performance
3. Add a layer of load balancing equipment and distribute it to different nodes to improve the overall performance
……