Answer: Reduce time for update query in Laravel (without for loop, for same key and multiple values)

answer re: Reduce time for update query in Laravel (without for loop, for same key and multiple values)

Dec 19 '18

2

As I suggested in the comment, one method is to refactor using a CASE WHEN clause.

You should be able to use a DB:raw select statement with your update method call.

$data = '(SELECT CASE Bib_no';
foreach ($ids as $i => $id) {
    if (!array_key_exists($i, $chestnos)) {
        /* uncomment to

…

Open Full Answer