Hacker News Reader

This is fascinating. What would be the solution for this? You can’t ask users to defrag.

Perform the file operation, after zipping the existing db as a backup, and leaving the original where it sits.

Success, performance increase.

Failure, no change.

Forgive my lack of knowledge, but how is simply zipping the original file would "defrag" the file?

Shouldn't the file be moved into different disk fragment first, for that to happen?

That's "the file operation" :]

Again: zip is a backup