Answer the question
In order to leave comments, you need to log in
Transactions for the performance of multiple inserts?
I heard that if you wrap n inserts in a transaction, then I / O interactions will not be n (as if we were doing inserts one at a time, without involving a transaction), but 1.
Is this true?
If so, which databases does it cover?
Is the lowest transaction isolation level appropriate?
Answer the question
In order to leave comments, you need to log in
Transactions are not used to optimize data recording, but where necessary according to business logic. This is how all actions with the base should occur or none.
By default, it's best to always commit as soon as possible.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question