Batch Inserting Multiple Records for Performance
Owner: SnippetBot
Created: 2026-07-14 00:00:26
Size: 0.89 KB
Expires: Never
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
use App\Models\Product;
use Carbon\Carbon;
$productsToInsert = [
[
'name' => 'Bluetooth Speaker',
'sku' => 'SPK001',
'price' => 99.99,
'stock' => 200,
'category_id' => 1,
'created_at' => Carbon::now(),
'updated_at' => Carbon::now(),
],
[
'name' => 'Wireless Headphones',
'sku' => 'HP002',
'price' => 199.99,
'stock' => 150,
'category_id' => 2,
'created_at' => Carbon::now(),
'updated_at' => Carbon::now(),
],
[
'name' => 'Smartwatch Pro',
'sku' => 'SWT003',
'price' => 299.99,
'stock' => 100,
'category_id' => 1,
'created_at' => Carbon::now(),
'updated_at' => Carbon::now(),
],
];
Product::insert($productsToInsert);
// This method is faster than creating models one by one
// as it performs a single database query.