alt Hacker NewsPerform the file operation, after zipping the existing db as a backup, and leaving the original where it sits.
Success, performance increase.
Failure, no change.
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?