Hi,
The subject of your mail is Is 60 write operations/sec really the limit
for H2?, but the Wikipedia paragraph you quote doesn't try to say that. It
tries to say that you can do 60 reliable fsync calls per second and disk.
Please note I just edit it to be more clear.
Probably wouldn't matter
Hi,
*According to documentation, the system doesn't call FileDescriptor.sync
() nor FileChannel.force () nor fsync
http://en.wikipedia.org/wiki/Sync_%28Unix%29 for every commit because
they significantly degrade system performance: only 60 write operations per
second
I think it means that is why it doesn't sync for every commit, so it can
get higher performance than that.
If it syncs for every commit, then if you are committing each row and
doing a lot of updates for example, then you get bad performance.
Probably wouldn't matter much for an SSD, but on a