Regarding the maximum data amount supported by THINKPHP's addAll, thinkphpaddall_PHP tutorial

Regarding the maximum amount of data supported by THINKPHP's addAll, thinkphpaddall

The Model operation in Thinkphp has two methods: add() and addAll

<span><span>1</span> <span>$User</span> = M("User"); <span>//</span><span> 实例化User对象</span>
<span>2</span> <span>$data</span>['name'] = 'ThinkPHP'<span>;
</span><span>3</span> <span>$data</span>['email'] = 'ThinkPHP@gmail.com'<span>;
</span><span>4</span> <span>$User</span>->add(<span>$data</span><span>);
</span><span>5</span> 
<span>6</span> <span>$dataList</span>[] = <span>array</span>('name'=>'thinkphp','email'=>'thinkphp@gamil.com'<span>);
</span><span>7</span> <span>$dataList</span>[] = <span>array</span>('name'=>'onethink','email'=>'onethink@gamil.com'<span>);
</span><span>8</span> <span>$User</span>->addAll(<span>$dataList</span>);</span>

The addAll method can add data in batches, which is how MySQL is used:

<pre name="code" class="sql"><span>INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);</span>

When there is a lot of data, try to insert in batches rather than inserting items one by one in a loop, otherwise your database will be overwhelmed and hang up.

However, if you take it for granted and store all the data into an array and perform addAll, you will also face a hang-up situation. Why is this?

The reason is that the configuration of the max_allowed_packet variable in mysql limits the length of the upload sql statement. Just configure it to be larger in the mysql configuration

<pre name="code" class="plain"><span>max_allowed_packet = 100M</span>

At the same time, when inserting data, you should also limit the length of batch insertion. After all, you never know when the data will become millions.

http://www.bkjia.com/PHPjc/951419.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/951419.htmlTechArticle Regarding the maximum amount of data supported by THINKPHP's addAll, thinkphpaddall There are two methods for Model operation in Thinkphp: add() and addAll 1 $User = M("User"); // Instantiate User object 2 $data ['name'...