总数据量:48865
菜菜的sql:
缺点:数据量上来一个子查询拖垮性能 能不用就不用
select *
from(
SELECT `user_id`, SUM(`reward_cash`) cash
from `A`
GROUP BY `user_id`) settle where settle.cash > 3000
结果:
正确的sql:
SELECT user_id, SUM(reward_cash) AS cash FROM `A`
GROUP BY `user_id`
HAVING cash >3000
这么少的数据量下,性能能提高了 23.5% =(155-118)/155