This might be true for SELECTs, but I found INSERTs are massively slower when compared to grouping in transactions.
Which should be obvious. But I could see some reading this blog post and jumping to the wrong conclusion.
It's not the cost of protecting one transaction from another transaction so much as the cost of flushing a transaction to storage to survive a crash.
In the bad old days you had to wait for a lever to move and for the disk to rotate at least once!
It's not the cost of protecting one transaction from another transaction so much as the cost of flushing a transaction to storage to survive a crash.
In the bad old days you had to wait for a lever to move and for the disk to rotate at least once!