What’s the real difference and when to use Chunk() and chunkById() from the Laravel

Question

It wasn’t very clear to me how the documentation works and I couldn’t find any content to fully explain how to use chunkById() and the difference practices for Chunk();

How do I return the result of chunkById() to the view? How do I paginate these records in the view? The way below doesn’t work...

DB::table('fornecedores')->orderBy('razao')->chunkById(100, function($fornecedores){
            foreach ($fornecedores as $fornecedor) {
                DB::table('fornecedores')
                    ->where('id', $fornecedor->id);
            }

Answer 1

The difference between the two is how pure SQL is mounted, the chunkById uses the id and limit when mounting sql, while the chunk uses limit and offset for example:

Using chunkById

select * from `fornecedores` where `id` > ? order by `razao` asc limit 10

Using Chunk

select * from `fornecedores` order by `razao` asc limit 10 offset 0

Chunk is not for paging, he is for you to process blocks of data that would normally be too heavy in cpu or memory to be done all together.

To paginate a query exists the paginate

public function index()
{
    $fornecedores = DB::table('fornecedores')->orderBy('razao')->paginate(10);

    return view('fornecedores.index', ['fornecedores' => $fornecedores]);
}

Then to display the data in the view is like this:

<div class="container">
    @foreach ($fornecedores as $fornecedore)
        {{ $fornecedore->id }}
    @endforeach
</div>

{{ $fornecedores->links() }}

I recommend reading the documentation here.