-----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----- _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
