I am confused about whether the following types of SQL statements need to be cached, how to cache them, and the update strategy. I hope you can give me some advice on associated query condition range queries, dynamic condition combinations, frequent data updates, and whether systems (CRM) that require real-time data are suitable for introducing cache-PHP Chinese website Q&A - Whether the following types of sql statements need to be cached, how to cache them, and the update strategy are confusing. I hope you can give me some advice on related query condition range queries, dynamic condition combinations, frequent data updates, and whether systems (CRM) that require real-time data are suitable for introducing caching - PHP Chinese website Q&A

Have a look and learn.

缓存要把控好，没有十全十美的实现，技术是永不停止的进步。
你的数据更新比较频繁，那就没有必要缓存了，可考虑加redis队列，防止堵塞。也可以配合swoole使用异步加载实现。
多用非关系型数据库，这样性能会提升一些。 如果在高并发情况还是实在不行的话，就再加几台服务器，利用负载均衡 lvs 来可实现减轻部分服务器的负载，redis最好部署分布式。