/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

2 votes116 views2 answers
How to use stored procedure in laravel
PHP
1 vote110 views1 answer
Laravel $loop interation
PHP
0 vote114 views2 answers
Create array php
PHP
0 vote123 views1 answer
Subquery in laravel
PHP Laravel
1 vote108 views1 answer
Laravel query select from table where id != to another table id
PHP
0 vote129 views1 answer
Laravel form validation based on another field value
PHP Laravel
0 vote128 views1 answer
Laravel select only some columns relationship
PHP Laravel
0 vote114 views1 answer
Php set x-frame-options
PHP
1 vote150 views2 answers
Laravel compare date timestamp
PHP Laravel
3 votes125 views3 answers
Laravel make view
PHP Laravel