php – 如何处理大型帖子请求

>使用准备好的陈述.这将允许MySQL缓存每个连续查询的内存操作.这非常重要.
>如果您使用预准备语句,则可以删除$c-> real_escape_string()调用.我也会挠头看看你可以放心地从$t-> clean()方法中省略什么.
>接下来,我将评估单独评估每一行的性能.我必须对它进行基准测试才能确定,但??我认为事先运行一些PHP语句比制作不必要的MySQL SELECT和UPDATE调用要快.一次插入多行时,MySQL要快得多.如果您希望输入的多行更改数据库中的同一行,那么您可能需要考虑以下事项：

一个.考虑创建一个临时的预编译数组(取决于所涉及的内存使用情况),该数组存储唯一的数据行.我也会考虑为辅助TABLE3做同样的事情.这将消除不必要的“更新”查询,并使b部分成为可能.

湾考虑单个查询,从数组中的数据库中选择每个id.这将是使用UPDATE查询的项目列表.更新每个行,然后将其从临时数组中删除.然后,您可以创建单个多行插入语句(当然是准备好的),它一次完成所有插入操作.
>看看优化MySQL服务器参数以更好地处理负载.
>我不知道这是否会加速准备好的INSERT语句,但它可能值得一试.您可以在事务中包装INSERT语句,详见答案：MySQL multiple insert performance

我希望这有帮助,如果其他人有一些建议,只需在评论中发布它们,我会尝试将它们包括在内.

以下是原始代码,只提供一些更改建议：

<?php
   /* You can make sure that the connection type is persistent and 
    * I personally prefer using the PDO driver.
    */
   include(db.php);
   /* Definitely think twice about each tool that is included.
    * Only include what you need to evaluate the submitted data.
    */
   include(tools.php);
   $c = new GetDB(); // Connection to DB
   /* Take a look at optimizing the code in the Tools class. 
    * Avoid any and all kinds of loops–this code is going to be used in 
    * a loop and could easily turn into O(n^2) performance drain. 
    * Minimize the amount of string manipulation requests. 
    * Optimize regular expressions.
    */
   $t = new Tools(); // Classes to clean,prevent XSS and others
   if(isset($_POST['var'])){ // !empty() catches more cases than isset()
       $nv = json_decode($_POST['var'])

       /* LOOP LOGIC
        * Definitely test my hypothesis yourself,but this is similar 
        * to what I would try first.
        */

       //Row in database query
       $inTableSQL = "SELECT id FROM TABLE1 WHERE id IN("; //keep adding to it

       foreach ($nv as $k) {
           /* I would personally use specific methods per data type.
            * Here,I might use a type cast,plus valid int range check.
            */
           $id = $t->cleanId($k->id); //I would include a type cast: (int)
           // Similarly for other values
           //etc.
           // Then save validated data to the array(s)
           $data[$id] = array($values...);
           /* Now would also be a good time to add the id to the SELECT
            * statement
            */
           $inTableSQL .= "$id,";
       }

       $inTableSQL .= ");";

       // Execute query here

       // Then step through the query ids returned,perform UPDATEs,// remove the array element once UPDATE is done (use prepared statements)

       foreach (.....

       /* Then,insert the remaining rows all at once...
        * You'll have to step through the remaining array elements to
        * prepare the statement.
        */
       foreach(.....

   } //end initial POST data if


       /* Everything below here becomes irrelevant */

       foreach($nv as $k) {
          $id = $t->clean($k->id);
          // ... goes on for about 10 keys
          // this might seems redundant or insufficient
          $id = $c->real_escape_string($id);
          // ... goes on for the rest of keys...

          $q = $c->query("SELECT * FROM table WHERE id = '$id'");
          $r = $q->fetch_row();
          if ($r[1] > 0) {
          // Item exist in DB then just UPDATE
             $q1 = $c->query(UPDATE TABLE1);
             $q4 = $c->query(UPDATE TABLE2);
             if ($x == 1) {
                 $q2 = $c->query(SELECT);
                 $rq = $q2->fetch_row();
                 if ($rq[0] > 0) {
                     // Item already in table just update
                     $q3 = $c->query(UPDATE TABLE3);
                 } else  {
                     // Item not in table then INSERT
                     $q3 = $c->query(INSERT TABLE3);
                 }
             }
          } else {
            // Item not in DB then Insert
             $q1 = $c->query(INSERT TABLE1);
             $q4 = $c->query(INSERT TABLE2);
             $q3 = $c->query(INSERT TABLE4);
             if($x == 1) {
                $q5 = $c->query(INSERT TABLE3);
             }
          }
       }
   }