3 ms·
They do, if you issue the transactions concurrently (i.e., multiple DB connections). This is "group commit" as referenced in the article. You can't batch sequ
by colanderman 2y ago
They do, if you issue the transactions concurrently (i.e., multiple DB connections). This is "group commit" as referenced in the article.
You can't batch sequential transactions without violating the semantics of `COMMIT`. (Data is after all not durable if it's not flushed to disk!) Hence such behavior is not the default in quality databases.
If you are issuing many sequential writes and you don't care about them being individually committed, you can and should group them.