php pdo测试批量insert into 和单条insert into对比详解数据库

             // 单条插入 
   for ($i = 0; $i < 1000; $i++) { 
            $name             = rand(1000, 9999); 
            $email            = rand(1000, 9999); 
            $message          = rand(1000, 9999); 
            $insertdata       = array('name' => $name, 'email' => $email, 'message' => $message); 
           $this->commoninsertinfo($insertdata,'aa'); 
        } 
          

      $insertdatalist = array(); 
        for ($i = 0; $i < 1000; $i++) { 
            $name             = rand(1000, 9999); 
            $email            = rand(1000, 9999); 
            $message          = rand(1000, 9999); 
            $insertdata       = array('name' => $name, 'email' => $email, 'message' => $message); 
            $insertdatalist[] = $insertdata; 
        } 
              $this->insertss($insertdatalist, 'aa');

  public function ssss() 
    { 
        /Db::beginTransactions(); 
        for ($i = 0; $i < 500; $i++) { 
            $name       = rand(1000, 9999); 
            $email      = rand(1000, 9999); 
            $message    = rand(1000, 9999); 
            $insertdata = array('name' => $name, 'email' => $email, 'message' => $message); 
            $this->commoninsertinfo($insertdata, 'aa'); 
        } 
 
        /Db::commits(); 
    } 
    public function shiwutest1() 
    { 
        set_time_limit(0); 
        ini_set("memory_limit", "512M"); 
        $begintime = time(); 
        $this->ssss(); 
        $this->ssss(); 
        $endtime = time(); 
        echo $endtime - $begintime; 
 
    }