using direct sql query to update multiple rows at time in magento 2 is good practise or not

Question

i have my custom module.i have to update multiple rows.if we follow the normal magento process i have to iterate through loop and update each at each time.so if there are large number of rows to update then it takes very long time to iterate the loop

foreach($row as $row)
{
/*  $update=$this->companyFactory->create();
                    $update->load($divaid,"divauniqueid");
                    $update->setStatus($statusid);
                    $update->save();*/
}

so i want use direct update query instead of iterate loop.which is the good .please help with this

Answer 1

Instead of writing direct sql queries, you can use the Resource model and write the code like following,

 $data = [
          'status' => 1,
         ];
    $connection->update($table, $data, ['entity_id = ?' => $model->getId()]);