DEV Community

Discussion on: Faster Eloquent Chunking

Collapse
 
kidipridi profile image
Kidi Pridi

Sure interesting post, but I'm against using eloquent when mass updating records as it updates one by one. I prefer to use update() on query builder, something like :

DB::table('posts')->where('published_at', '<', now())->update(['published_at' => now()]);
Enter fullscreen mode Exit fullscreen mode

It will result query like this :

update `posts` set `published_at` = 2019-09-25 07:09:55 where `published_at` < 2019-09-25 07:09:55
Enter fullscreen mode Exit fullscreen mode
Collapse
 
mennowolvers profile image
Menno Wolvers • Edited

This is indeed faster but be careful that your Observers wont be called with this method.