SELECT t1.*,t2.* FROM dungeon_ext t3
JOIN dungeon_team t2 ON ( t2.dungeonId = t3.dungeonId AND t2.characterType = 'healer')
JOIN dungeon t1 ON ( t1.dungeonId = t3.dungeonId AND t1.dungeonName='阿塔达萨' )
ORDER BY t3.score DESC limit 0,50
dungeon 大概300w行左右
dungeon_team 大概700w行左右
然后现在大概运行一次要5分钟。
请问有什么办法优化下吗~
explain,看看dungeon_ext是不是驱动表,如果不是,改成SELECT STRAIGHT_JOIN t1.*,t2.*试试
在关键字段加上索引