As it was stated, chunks won’t really help you in this case if it is a time execution problem. I think that bulk insert you are trying to use cannot handle that amount of data , so I see 2 options: 1 – Reorganise your code to properly use chunks, this will look something like … Read more
It’s mostly raw queries: DB::table(‘item_details’)->selectRaw(‘GROUP_CONCAT(…) INTO @sql’)->get(); DB::statement(‘SET @sql = CONCAT(…)’); DB::statement(‘PREPARE stmt FROM @sql’); DB::statement(‘EXECUTE stmt’); DB::statement(‘DEALLOCATE PREPARE stmt’); Try this: DB::table(‘item_details’)->selectRaw(‘GROUP_CONCAT(…) INTO @sql’)->get(); $sql = DB::selectOne(‘select @sql’)->{‘@sql’}; ItemDetails::select(‘item_number’, DB::raw(‘SUM(quantity) as total_quantity’)) ->selectRaw($sql) ->groupBy(‘item_number’) ->get();