Home Backend Development PHP Tutorial Chunk set processing in Laravel

Chunk set processing in Laravel

Aug 21, 2017 am 10:20 AM
laravel deal with

If you need to process thousands of Eloquent results, you can use the chunk command. The chunk method will get a "chunk" Eloquent model and populate it into the given closure for processing. Using the chunk method can effectively reduce memory consumption when processing large data collections:


Flight::chunk(200, function ($flights) {
    foreach ($flights as $flight) {
        //
    }
});
Copy after login


        $all_ark=Arkvolume::chunk(50000, function ($flights) {
            foreach ($flights as $flight) {
               $GLOBALS['something'][] = $flight['id'];
            }
        });

        var_dump($GLOBALS['something'] );exit;
Copy after login

This paragraph The code is to execute a 100-piece data update, and when the execution is completed, continue with another 100 pieces of data...
That is to say, each time he operates a data block instead of the entire database.

It should be noted that when using chunks with filtering conditions, if it is self-updating, you will miss some data. Next, look at the code:


##

User::where('approved', 0)->chunk(100, function ($users) {
  foreach ($users as $user) {
    $user->update(['approved' => 1]);
  }
});
Copy after login

If you want to run the above code, there will be no error, but the

where condition is to filter the user## that approved is 0 #Then update the value of approved to 1. In this process, after the data in the first database is modified, the data in the next data block will be selected from the modified data. At this time, the data has changed, and the page has also been increased by 1. Therefore, after the execution, only half of the data in the data has been updated.
If you don’t understand, let’s take a look at the underlying implementation of chunk. Taking the above code as an example, if there are 400 pieces of data in total, the data is divided into blocks according to 100 pieces.

page = 1: At the beginning, the page is 1, and 1-100 pieces of data are selected for processing;

page = 2: At this time, the
approved
values ​​of the first 100 pieces of data are all 1. Then in the first screening, the data will start from the 101st item, and at this time page=2, then the data processed will be the data before 200-300 and still after.

public function chunk($count, callable $callback)
{
    $results = $this->forPage($page = 1, $count)->get();

    while (count($results) > 0) {
        // On each chunk result set, we will pass them to the callback and then let the
        // developer take care of everything within the callback, which allows us to
        // keep the memory low for spinning through large result sets for working.
        if (call_user_func($callback, $results) === false) {
            return false;
        }

        $page++;

        $results = $this->forPage($page, $count)->get();
    }

    return true;
}
Copy after login

The above is the detailed content of Chunk set processing in Laravel. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP vs. Flutter: The best choice for mobile development PHP vs. Flutter: The best choice for mobile development May 06, 2024 pm 10:45 PM

PHP vs. Flutter: The best choice for mobile development

Laravel - Artisan Commands Laravel - Artisan Commands Aug 27, 2024 am 10:51 AM

Laravel - Artisan Commands

How to use object-relational mapping (ORM) in PHP to simplify database operations? How to use object-relational mapping (ORM) in PHP to simplify database operations? May 07, 2024 am 08:39 AM

How to use object-relational mapping (ORM) in PHP to simplify database operations?

Analysis of the advantages and disadvantages of PHP unit testing tools Analysis of the advantages and disadvantages of PHP unit testing tools May 06, 2024 pm 10:51 PM

Analysis of the advantages and disadvantages of PHP unit testing tools

PHP distributed system architecture and practice PHP distributed system architecture and practice May 04, 2024 am 10:33 AM

PHP distributed system architecture and practice

Comparison of the latest versions of Laravel and CodeIgniter Comparison of the latest versions of Laravel and CodeIgniter Jun 05, 2024 pm 05:29 PM

Comparison of the latest versions of Laravel and CodeIgniter

How do the data processing capabilities in Laravel and CodeIgniter compare? How do the data processing capabilities in Laravel and CodeIgniter compare? Jun 01, 2024 pm 01:34 PM

How do the data processing capabilities in Laravel and CodeIgniter compare?

PHP code unit testing and integration testing PHP code unit testing and integration testing May 07, 2024 am 08:00 AM

PHP code unit testing and integration testing

See all articles