/PHP/Laravel/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

1 vote143 views1 answer
How convert big text to array that text have br in laravel
PHP Laravel
0 vote134 views1 answer
Laravel eloquent get 3 months
PHP Laravel
0 vote127 views1 answer
Passing parameters with route keyword in blade laravel
PHP Laravel
3 votes235 views2 answers
Laravel eloquent get one column value
PHP Laravel
0 vote163 views1 answer
Adding data to a laravel collection
PHP Laravel
0 vote140 views2 answers
Laravel Read CSV File
PHP Laravel
1 vote194 views1 answer
Laravel pagination publish command
PHP Laravel
0 vote145 views1 answer
Menyimpan get di laravel
PHP Laravel
0 vote136 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
2 votes140 views2 answers
Laravel migration alter column unique
PHP Laravel