/PHP/Laravel query get big table records

Laravel query get big table records

#METHOD 1
DB::table('users')->orderBy('id')->chunk(100, function ($users) {
    foreach ($users as $user) {
        //
    }
});

#METHOD 2
foreach (DB::table('users')->orderBy('id')->cursor() as $flight) {
    //
}

Source: stackoverflow.com

Similar codes

0 vote108 views1 answer
Upload images php mysql
PHP
0 vote137 views1 answer
[InvalidArgumentException] Could not find package symfony/web-server-bundle in a version matching 5.0.
PHP Symfony
7 votes130 views2 answers
Laravel seeder with relationships
PHP Laravel
0 vote121 views1 answer
Laravel get all users except role spatie
PHP Laravel
1 vote99 views1 answer
Laravel route fallback
PHP
0 vote110 views1 answer
Laravel weekly data
PHP
0 vote110 views1 answer
Php dom get element innerhtml
PHP
0 vote103 views1 answer
E_notice in php
PHP
5 votes112 views3 answers
Drop column table in migration if exist in laravel
PHP
0 vote113 views1 answer
Laravelstart project
PHP