Proper MySQL Bulk Update in Laravel?

Question

MySQL

There are about 10,000 products, you need to update prices by category, for each group of products by category there are certain price increase rates. But is it correct to do the update inside the loop?

There is only one solution that comes to mind right now:

// И так более 10 тысяч запросов за раз
foreach($products as $p) {
Products::where('id', $p->id)->update(['price' => $newPrice]);
}

Is it correct to do a mass update this way?

Answer 1

If there are no event hooks associated with these fields, then it's better to do everything through bulk operations (and yes, arbitrary expressions can also be used there )