| 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.