save big data with laravel
$insert_data = []; foreach ($json['value'] as $value) { $posting_date = Carbon::parse($value['Posting_Date']); $posting_date = $posting_date->format('Y-m-d'); $data = [ 'item_no' => $value['Item_No'], 'entry_no' => $value['Entry_No'], 'document_no' => $value['Document_No'], 'posting_date' => $posting_date, .... ]; $insert_data[] = $data; } $insert_data = collect($insert_data); // Make a collection to use the chunk method // it will chunk the dataset in smaller collections containing 500 values each. // Play with the value to get best result $chunks = $insert_data->chunk(500); foreach ($chunks as $chunk) { \DB::table('items_details')->insert($chunk->toArray()); }
