What If: My QuickBooks File is Badly Fragmented?

by

by

Comments (3)

Comment Feed

DB Fragments and an SSD

Robin is correct about SSDs. We are told NOT to defragment an SSD drive.The only way that I have successfully reduced a file's fragmentation on an SSD is through the creating a Portable File then restoring it as a QBW file at least 2xs.

Leslie Simmons 95 days ago

DB File Fragments

I have seen customers who use SDD solid state "disk drives" where F2 shows over 1000 DB File Fragments, with no apparent impairment of processing speed.

Robin F Macdonald 103 days ago

Fragmentation inconsequential on SSDs

Fragmentation really is a 'non-concept' on a Solid State Drive. While it is true that SSDs do get fragmented from the standpoint that files (or portions thereof) maybe out of order or sequence within SSD memory, fragmentation on SSDs does not hinder performance because each 'extent' has to be processed by the file system when the file is altered.

As such SSDs do not require defragmentation and in fact fragmentation may actually be a good thing for SSDs because it is consistent with wear leveling technology that helps to prolong SSD useful life.

I'm not really sure that the QuickBooks routine used to report the DB File Fragments in the F2 window is even designed to make such a measure when checking data on an SSD, so the figure reflected could just as likely be unreliable as reliable, in my way of thinking.

insightfulaccountant.com 103 days ago

a small ad separator
Click to Subscribe
a small ad separator
a small ad separator
a small ad separator
a small ad separator