Hacker News new | ask | show | jobs
by nemo44x 4304 days ago
Why are update statements actually inserts? Am I missing something ( besides eventually consistency by design ) or are they trying to trick me?
1 comments

Because they don't do a read before insert/update/delete, so random inserts don't do random reads/io, but create new versions.

They aren't trying to trick you. Bigtable,hypertable,hbase (i think even tokudb/mx) work the same.