MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:January 6 2000 3:25am
Subject:Re: Sequential Updates
View as plain text  
Cheng-Wei Cheng wrote:
> 
> I have three update in a row from php
> would that cause any problem?
> I see that as one of the to do in mysql so I am a bit concerned
> 
> thanks
> cheng

Not really, but you can optimize performance by lock tables before the updates
and unlock tables after.

> 
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread23206@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-sasha=sashanet.com@stripped>

-- 
Sasha Pachev

+------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sasha@stripped  |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
Request for opinions regarding perfomance (LONG)Leonard Rosenbeck6 Jan
  • RE: Request for opinions regarding perfomance (LONG)Cheng-Wei Cheng6 Jan
    • RE: Request for opinions regarding perfomance (LONG)sinisa6 Jan
  • Sequential UpdatesCheng-Wei Cheng6 Jan
    • Re: Sequential UpdatesSasha Pachev6 Jan
  • Re: Request for opinions regarding perfomance (LONG)Sasha Pachev6 Jan
    • Re: Request for opinions regarding perfomance (SHORT)Mark Zieg6 Jan
  • Re: Request for opinions regarding perfomance (LONG)Benjamin Pflugmann7 Jan
    • How do I..Cheng-Wei Cheng7 Jan
      • Re: How do I..sinisa7 Jan
      • Re: How do I..Paul DuBois7 Jan
Re: Sequential UpdatesSasha Pachev6 Jan