F
F
floppa3222020-09-14 14:52:59
Database
floppa322, 2020-09-14 14:52:59

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

1 answer(s)
@
@insighter, 2020-09-16
_

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 question

Ask a Question

731 491 924 answers to any question