On 07/14/2010 03:19 AM, Michael Hudson wrote:
> UPDATE CodeImportMachine SET heartbeat=CURRENT_TIMESTAMP AT TIME ZONE
> 'UTC' WHERE CodeImportMachine.id = %s
Is there an index on CodeImportMachine.id, and will it be used in this
case? I fixed a similar problem once in Bugzilla that resulted from a
DELETE not using an index, and thus doing a table scan and also locking
the whole table.
-Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
_______________________________________________
Mailing list: https://launchpad.net/~launchpad-dev
Post to : [email protected]
Unsubscribe : https://launchpad.net/~launchpad-dev
More help : https://help.launchpad.net/ListHelp
