Hi Guys,
UPDATE table1 SET col1='True'
This query takes more than 30 secs for about 6000 records. Why is it so slow?
views:
363answers:
1
+4
A:
Do you have a trigger?
And see my answers here too: Why does an UPDATE take much longer than a SELECT?
gbn
2010-01-23 07:32:52
I had trigger, temporarily turning off the trigger did the magic.ALTER TABLE table1 DISABLE TRIGGER ALL UPDATE table1 SET Col1='True' ALTER TABLE table1 ENABLE TRIGGER ALL
Rajesh
2010-01-23 08:19:33