Comment by didip Comment by didip 2 days ago 3 replies Copy Link View on Hacker News This is fascinating. What would be the solution for this? You can’t ask users to defrag.
Copy Link DANmode 2 days ago Collapse Comment - 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. Reply View | 2 replies Copy Link axitanull a day ago Parent Collapse Comment - 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? Reply View | 1 reply Copy Link DANmode a day ago Root Parent Collapse Comment - That's "the file operation" :]Again: zip is a backup Reply View | 0 replies
Copy Link axitanull a day ago Parent Collapse Comment - 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? Reply View | 1 reply Copy Link DANmode a day ago Root Parent Collapse Comment - That's "the file operation" :]Again: zip is a backup Reply View | 0 replies
Copy Link DANmode a day ago Root Parent Collapse Comment - That's "the file operation" :]Again: zip is a backup Reply View | 0 replies
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.