PHP Fatal error: bytes exhausted After running query

Question

Hello, in a certain process of my code I need to execute a query that returns me 4500 rows from the database

 return Property::whereHas('portals', function ($query) {
        $query->where('portal_id', '=', '1');
    })->get();

After running this query I do a check on each line.

The problem is that before checking php accuses a memory error PHP Fatal error: Allowed memory size of 16777216 bytes exhausted

In local environment I changed the memory_limit in php.ini to 512M and the function ran OK. The problem is that this is not a solution for me, that I will run it on online server.

I need to split this result before I run the check, but I don’t know how, someone can help me?

Answer 1

Depends on the version of your Laravel, in older versions you can use:

 return Property::whereHas('portals', function ($query) {
    $query->where('portal_id', '=', '1');
})->take(10)->skip(10)->get();

Who would take (TAKE) 10 results after skipping (SKIP) the top 10;

In more recent versions the code would be:

return Property::whereHas('portals', function ($query) {
    $query->where('portal_id', '=', '1');
})->limit(10)->offset(10)->get();

Then to page your result you would only change the OFFSET or SKIP.