UPDATE table1 SET col1='True'
This query takes more than 30 secs for about 6000 records. Why is it so slow?
更新表1 SET col1='True'这个查询占用了超过30秒的6000条记录。为什么这么慢?
1 个解决方案
#1
6
Do you have a trigger?
你有扳机吗?
And see my answers here too: Why does an UPDATE take much longer than a SELECT?
在这里也可以看到我的答案:为什么更新要比选择花费更长的时间?
#1
6
Do you have a trigger?
你有扳机吗?
And see my answers here too: Why does an UPDATE take much longer than a SELECT?
在这里也可以看到我的答案:为什么更新要比选择花费更长的时间?