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.

Thread
Slower performance with LOCK TABLESHank22 Sep
  • Re: Slower performance with LOCK TABLESAntony T Curtis22 Sep
    • Re: Slower performance with LOCK TABLESHank22 Sep
Re: Slower performance with LOCK TABLESAntony T Curtis22 Sep
  • Re: Slower performance with LOCK TABLESHank22 Sep
    • Re: Slower performance with LOCK TABLESAnanda Kumar22 Sep
      • Re: Slower performance with LOCK TABLESHank22 Sep
        • Re: Slower performance with LOCK TABLESAnanda Kumar22 Sep
          • Re: Slower performance with LOCK TABLESHank22 Sep
            • Re: Slower performance with LOCK TABLESAnanda Kumar22 Sep
              • Re: Slower performance with LOCK TABLESHank22 Sep
                • Re: Slower performance with LOCK TABLESAnanda Kumar22 Sep
                • Re: Slower performance with LOCK TABLESJohan De Meersman23 Sep
                  • Re: Slower performance with LOCK TABLESHank23 Sep
                  • Re: Slower performance with LOCK TABLESHank23 Sep
                    • Re: Slower performance with LOCK TABLESJohan De Meersman26 Sep
                  • Re: Slower performance with LOCK TABLEShsv23 Sep
Re: Slower performance with LOCK TABLESHank22 Sep