logoalt Hacker News

hnlmorgtoday at 4:14 PM1 replyview on HN

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.


Replies

PaulHouletoday at 4:22 PM

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!

show 1 reply