mardi 1 octobre 2019

Why "Allowed Memory Size Exhausted" error turns out when using bigger size database

I had using eloquent relationship in my query (controller).

  $items = Item::with('section','category')
                       ->where('item.statusid', '=', 1)
                       ->get();

I had tested in my local and development server and success. But when I use the production database to the same code, it turns error:

   "Allowed Memory Size Exhausted"

I had tried changing php memory limit and disable query log, but failed. What else can I do to fix this?

Update: The current production db with 'item' table consists of 1178 rows.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire