Laravel – `syncWithoutDetaching()` vs `insertOrIgnore()`

  • Post category:Snippets

In a tweet by Tom Herrmann (@devgummibeer) (https://gummibeer.dev/), he discussed how using syncWithoutDetaching() call can kill a database. Basically, instead of doing: $user->identifiers()->syncWithoutDetaching($identifiers); Do this: DB::table('identifier_user')->having()->insertOrIgnore( $identifiers->map(fn (Identifier $identifier) =>…

Continue ReadingLaravel – `syncWithoutDetaching()` vs `insertOrIgnore()`