Hacker News new | ask | show | jobs
by didip 236 days ago
This is fascinating. What would be the solution for this? You can’t ask users to defrag.
1 comments

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