数据库目前有100万数据(运行了半个月左右)
下面这句运行要6秒(单单where的结果有100万),user_id和time都加索引了
SELECT user_id,count(*) as count from prize_numbers where user_id > 0 and time > 1545972485 GROUP BYuser_id ORDER BY count desc
下面这句也是一样的,要6秒
SELECT user_id,count(*) as count from ( SELECT user_id from prize_numbers where user_id > 0 and time > 1545972485)t GROUP BY user_id ORDER BY count desc
该怎么优化 ?
这是表结构
慕田峪9158850
动漫人物