以下类型的sql语句，是否需要缓存，怎么缓存，更新策略比较疑惑，望指点 关联查询 条件范围查询 动态条件组合 频繁的数据更新，需要数据实时的系统（CRM）是否适合引入缓存

数据分析师2017-10-01 00:23:55

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.

怪我咯2017-02-17 13:30:43

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