select advlink,count(id) as clickcount,count(distinct ip) as ipcount,count(distinct cookievalue) as cookiecount from advlogs20081228 group by advlink;
advlogs20081228 这个表 80多万数据 执行需要 2分钟
大家看看有没有方法优化
...全文
3693打赏收藏
mysql distinct order by 性能问题
select advlink,count(id) as clickcount,count(distinct ip) as ipcount,count(distinct cookievalue) as cookiecount from advlogs20081228 group by advlink; advlogs20081228 这个表 80多万数据 执行需要 2分钟 大家看看有没有方法优化