Yii2 how to do multiple inserts/deletions/updates?

Question

Yii

How to select, insert, delete, update data without a loop? And how to exclude updating of fields which have not changed?

Answer 1

There is a batch insert in yii2: www.yiiframework.com/doc-2.0/yii-db-command.html#b...
It can be used for multiple inserts
For multiple updates, you can use it, with some modifications (adding ON DUPLICATE KEY UPDATE)
But about mass deletion, probably just IN, like this: ->where(['IN', 'id', $ids])

Answer 2

Regular insert (batch update):
I can not find confirmation, but it seems to me that the transaction will allow you to work with the cycle without problems.
Inserting 10,000 records in one transaction?