谢谢上面得回复,仔细看了下,再执行insert 之前 update 表A set is_use=1 where id in (1,2,……180)。准确说就是执行这个update 得时候时间好几分钟,update 如果在范围100多个 就会这么慢吗?有没有好得方法,谢谢了!表A里有8万条记录
难道id不是主键 or 没有索引?
UPDATE FROM customerinfo SET is_use=1 WHERE CustomerID NOT in (SELECT CustomerID FROM salesinfo )
UPDATE FROM customerinfo SET is_use=1 WHERE CustomerID NOT in (SELECT CustomerID FROM salesinfo ) 逐条检查下了速度,发现就是mysql处理子查询得时候速度很卡,语句还有什么方式可以调整下?
update customerinfo a left join salesinfo b on a.CustomerID=b.CustomerID set a.is_use=1 where b.CustomerID is null;create index xxx on salesinfo (CustomerID )
WHERE CustomerID NOT in (SELECT CustomerID FROM salesinfo )
WHERE CustomerID NOT in (SELECT CustomerID FROM salesinfo ) 逐条检查下了速度,发现就是mysql处理子查询得时候速度很卡,语句还有什么方式可以调整下?
on a.CustomerID=b.CustomerID
set a.is_use=1
where b.CustomerID is null;create index xxx on salesinfo (CustomerID )