About the maximum amount of data supported by THINKPHP's addAll

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

<spanmicrosoft yahei font-size:><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>);</spanmicrosoft>

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

<spanmicrosoft yahei font-size:>INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);</spanmicrosoft>

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

<spanmicrosoft yahei font-size:>max_allowed_packet = 100M</spanmicrosoft>

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.

The above introduces the maximum data volume supported by THINKPHP's addAll, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.