Laravel 保存很多模型太慢

假设:我假设所有表都有自动增量的id列(主要关键字)

参考摘自:Bulk insert and get returned ids laravel

这是我建议的代码:

function insertVariant(Request $request) {
    $datas = $request->all();

    $id = $options->insertGetId(
        [
            'name'=>'$data['color'] ,
        ]
        , 
        [
            'name'=>'$data['size'] ,
        ]
    ]); // check that $options is created and a valid object

    // 1- get the last id of your table SKU say $lastIdBeforeInsertionInSkuTable
    // 2- get the last id of your table VariantValue say $lastIdBeforeInsertionInVariantValueTable


    $skuArray = []
    $variantValueArr = [];

    foreach ($datas in $data) {    
          $sku = [
             'name' => $data['sku'],
             'price' => $data['price'],
             'quantity' => $data['quantity'],
          ];

         $skuArray[] = $sku;
         
         //Using value1 and value 2 because the same index values got over-written, so check and fix it at your end
         $variantValue = [
            'variant_options_id' => $id[0],
            'value1' => $data['color'],
            'value2' = $data['size'],
         ];
         $variantValueArr[] = $variantValue;
    }

    SKU::insert($skuArray);
    VariantValue::insert($variantValueArr);

    $skuIds = [];
    $variantValueIds = [];
    for($i=1; $i<=count($skuArray); $i++){
        $skuIds[] = $lastIdBeforeInsertionInSkuTable+$i;
        $variantValueIds[] = $lastIdBeforeInsertionInVariantValueTable+$i;
    }

    $skuVariantValuesArr = [];
    foreach($skuIds as $key=>$skuId){
        $skuVariantValuesArr[] = [
            'variant_value_id' =>$variantValueIds[$key],
            'sku_id' =>$skuId
        ];
    }
    SKUVariantValues::insert($skuVariantValuesArr);
}

注意:仔细阅读代码内的 comments 并相应地工作.