QuickBooks Performance: Reducing Company File Fragments

The following article will help you identify the number of fragments in your QuickBooks company file, and reduce the number of fragments to improve performance.  To see how much your QuickBooks company database (DB) file is fragmented:

Open the file in QuickBooks and press F2 to open the Product Information screen.  Look at the number of DB File Fragments. It is normal to see some file fragments.

However, if the number of file fragments is greater than 100, your file may be fragmented enough to noticeably affect performance.  If this is the case, we recommend performing a QuickBooks Verify Data and then a Rebuild Data:

http://helpdesk.novelaspect.com/hc/en-us/articles/203547369-Address-QuickBooks-issues-performance-crashes-missing-data-Verify-and-Rebuild-Data

If the verify and rebuild process does not reduce the file fragmenting, the next step should be to create and restore a portable backup copy of your file:

http://helpdesk.novelaspect.com/hc/en-us/articles/203547659

NOTE: creating a portable copy will also reduce the size of your .TLG file which can also help with performance.  See the following article for more information about the .TLG file:

http://helpdesk.novelaspect.com/hc/en-us/articles/203547749-Reduce-TLG-file-size-Improve-File-Health-and-Performance