现在有3张表,每张表大概80w 记录,现在对三张表进行Join 发现需要5秒左右,用profiling 发现大部分时间消耗在sending data.select e.id
from a as e
join b as f on e.id=f.id
join c as g on e.id=g.id其中Id 是三个表中的主键。
from a as e
join b as f on e.id=f.id
join c as g on e.id=g.id其中Id 是三个表中的主键。
districtlist已建索引,以下是查询语句:
select `phone`,`seat` from `numbers` where `districtlist`=3 order by `porder` asc limit 101182