Level 75
You can specify size, second argument is the callback.
DB::table('users')->orderBy('id')->chunk(100, function ($users) {
// Process the records...
return false;
});
Aug 28, 2019
4
Level 7
Chunking queries
Hi guys, I would like to share one quick tip. It might be obvious for some but for others a big time saver.
Tip: In Laravel ->each() method on query builder does chunking by default (1000 items per chunk), and you can set chunk size using the second parameter, for example, User::each(function($user) {...}, 500);.
Ref.: https://github.com/laravel/framework/blob/5.7/src/Illuminate/Database/Concerns/BuildsQueries.php#L58
Level 7
@jlrdw yeap - that's the way I used to chunk until I discovered I can use User::each(function($user) {...}); and Laravel will handle chunking behind scenes by default.
Level 75
Also you have this under laravel, you may want to change it to guides or tips. Just a thought.
Level 7
Good tip :). Thanks - moved to Tips.
Please or to participate in this conversation.