An analysis of the maximum number of data _php examples supported by thinkphp AddAll

The model operation in Thinkphp has two methods: Add () and AddAll

Copy Code code as follows:

$User = M ("User"); Instantiating the User object
$data [' name '] = ' thinkphp ';
$data [' email '] = ' ThinkPHP@gmail.com ';
$User->add ($data);
$dataList [] = Array (' name ' => ' thinkphp ', ' email ' => ' thinkphp@gamil.com ');
$dataList [] = Array (' name ' => ' onethink ', ' email ' => ' onethink@gamil.com ');
$User->addall ($dataList);

The AddAll method can do the function of adding data in bulk, which is the usage of MySQL:

Copy Code code as follows:

INSERT into Tbl_name (a,b,c) VALUES (1,2,3), (4,5,6), (7,8,9);

The amount of data in many cases to choose the bulk insert instead of the loop-by-article insertion, otherwise your database will not eat hang out.

But what if you take it for granted that all the data is stored in an array and AddAll is also going to hang up?

The reason is that the configuration of the Max_allowed_packet variable in MySQL limits the length of the uploaded SQL statement, and it's a bit larger in MySQL configuration.

Max_allowed_packet = 100M

At the same time insert the data also do a lot of the length of the insertion limit, after all, you do not know when the data will become millions other.

The above is the entire content of this article, I hope that the small partners can enjoy.