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());
}

Source: stackoverflow.com

Save big data with laravel

ini_set('max_execution_time', 120 ) ; // time in seconds

$insert_data = [];

foreach ($json['value'] as $value)
{
   ...
}

Source: stackoverflow.com

Similar codes

0 vote349 views1 answer
Laravel eloquent with query parameter
PHP Laravel
0 vote352 views1 answer
Convert image to base64 in laravel
PHP Laravel
0 vote365 views1 answer
Validate audio file in laravel
PHP Laravel
2 votes351 views4 answers
How to create controller inside folder in laravel
PHP Laravel
15 votes302 views6 answers
Laravel custom validation message
PHP Laravel
12 votes346 views6 answers
Laravel model where
PHP Laravel
21 votes301 views5 answers
Laravel 7 auth command
PHP Laravel
0 vote318 views1 answer
Laravel get data from model to controller
PHP Laravel
0 vote324 views1 answer
Laravel collection pop
PHP Laravel
0 vote345 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel