Shulou(Shulou.com)06/03 Report--

This article focuses on "how to understand the maximum amount of data supported by THINKPHP's addAll". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to understand the maximum amount of data supported by THINKPHP's addAll.

There are two methods for Model operations in Thinkphp: add () and addAll

The copy code is as follows:

$User = M ("User"); / / instantiate 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 add data in batches, which is the use of MySQL:

The copy code is as follows:

INSERT INTO tbl_name (a recorder brem c) VALUES (1m 2je 3), (4m 5m 6), (7m 8je 9)

In many cases, try to insert in bulk rather than loop one by one, otherwise your database will not be able to eat and die.

But if you take it for granted that you put all the data into an array and addAll it, you will also face the situation of dying. Why?

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 a little larger in the mysql configuration.

Max_allowed_packet = 100m

At the same time, there is also a limit on the length of bulk inserts when inserting data. after all, you don't know when the data will become millions.

At this point, I believe you have a deeper understanding of "how to understand the maximum amount of data supported by THINKPHP's addAll". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.