LARAVEL Fatal Error Exception : Allowed memory size of 134217728 bytes exhausted (tried to allocate 10489856 bytes)

laravel memory-limit
skadevz picture skadevz · Aug 30, 2017 · Viewed 10.6k times · Source

i want to run this code

$late = Attendance::whereUserType(5)
         ->where('datetime_in', '!=', null)
         ->where(DB::connection('attendance')
         ->raw('DATE(created_at)'), date('Y-m-d'))
         ->orderBy('user_id')->get()->take(10);

but i got an error like in the title said. When i change the memory_limit to 512M, my browser is lag. I'm using 16K+ data for testing, is it ok ?? And what is the problem ??

Answer

Cengkuru Michael picture Cengkuru Michael · Oct 13, 2017

Try to add this on top of the script

ini_set('memory_limit','512M');

Your query could be timing out

Related questions

Laravel DB Insert Error: Allowed Memory Size Exhausted

I'm running into an issue when trying to insert ~20K records into my DB. I notice that even though I'm echoing inside my foreach loop, I'm not getting anything outputted in the command line. Instead, I get an error after …

Read More
How Do I Get the Query Builder to Output Its Raw SQL Query as a String?

Given the following code: DB::table('users')->get(); I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users. How do I do …

Read More
How to Create Multiple Where Clause Query Using Laravel Eloquent?

I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not elegant. Example: $results = User::where('this', '=', 1) ->where('that', '=', 1) …

Read More