launchpad-dev team mailing list archive

[John Arbash Meinel <john@xxxxxxxxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Max Kanat-Alexander wrote:
> 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

CodeImportMachine.id is the primary key of the table. So it has the
appropriate unique+not null index.

John
=:->
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Cygwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkw/9sUACgkQJdeBCYSNAANuyQCggim1UsHbd43RLLxRLdKMUSpx
5sQAn2idLewyJYTKUVSmrSNLOlNtNYfG
=plk9
-----END PGP SIGNATURE-----