launchpad-dev team mailing list archive

[Max Kanat-Alexander <mkanat@xxxxxxxxxxxx>]

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.