|List:||General Discussion||« Previous MessageNext Message »|
|From:||(Hal||Date:||September 23 2011 3:02pm|
|Subject:||Re: Slower performance with LOCK TABLES|
|View as plain text|
>>>> 2011/09/23 12:56 +0200, Johan De Meersman >>>> What it says, is "If you are going to run many operations". You are updating many rows, but you are only doing ONE operation: a single update statement. <<<<<<<< For what it's worth, the downloading HTML help claims this only for MyISAM tables, because between "LOCK TABLES" and "UNLOCK TABLES" there is no key-cache flushing. InnoDB is not mentioned.