mysql delete 删除速度慢
猜不到的c 2016-12-16 04:25:03 DELETE
FROM
productionprocedure
WHERE
productionorderid IN (
SELECT
productionorderid
FROM
salesproduction
WHERE
salesorderid = '45f49726-76ff-4e2e-be8b-fbea6c3a4546'
)
DELETE
FROM
productionprocedure
WHERE
EXISTS (
SELECT DISTINCT
s.productionorderid
FROM
salesproduction s
WHERE
s.productionorderid = productionprocedure.productionorderid
AND salesorderid = '45f49726-76ff-4e2e-be8b-fbea6c3a4546'
)
productionprocedure表与salesproduction表也就几千条数据,select子查询结果有6条数据,但是执行删除语句的时候却用了6秒多钟。。太慢了,数据库引擎是innodb。 有解决方法吗,执行结果一样,都是删除语句,一个用的是delete..in ,一个用的是delete... exists. (效率差不多,都是6秒多钟)