Skip to main content
T
topherfarrell
May 6, 2025
Question

File compression or deletion of Audit Trail?

  • May 6, 2025
  • 1 reply
  • 0 views

Hello,

I’ve got a company file that’s nearing 4GB in size. We’ve been using the same file since we first set up Enterprise back in 2010. It functions but has been slowly getting more and more sluggish in recent years. I do routine maintenance to speed things up like deleting ND and TLG files. This weekend I’m planning to delete the audit trail (I’m told this is a large amount of the data and can speed up the user experience as well as remedy corrupt transactions, etc). But I’ve also been told that creating a new company file and just migrating data for customers, vendors and inventory/items would be a better method. I’m also aware of file compression, which I’ve heard is not the best of the three options. 

 

I figured I would post here and hopefully get some feedback, experiences, suggestions, etc. Which of these options have any of you tried and what were the outcomes?

1 reply

S
SIAB
May 7, 2025

Running a data condense utility is always the best choice. Why do you hesitate?

T
topherfarrellAuthor
May 7, 2025

Hesitation is due to the fact that we’ve never done it. I just want to make sure I take the best route. Does the compression option leave all of my inventory assemblies, customers & vendors intact? Will I still be able to access transactions that are, say, over 5 years old? Can the file condense cause corruption?

S
SIAB
May 7, 2025

Does the compression option leave all of my inventory assemblies, customers & vendors intact?

Yes

 

Will I still be able to access transactions that are, say, over 5 years old?

You will have a condensed file and the original file. You can still open the original file anytime to access it.

 

Can the file condense cause corruption?

On the contrary. If your file is corrupted, you will not be able to run the data condense utility. You will need to purchase a third-party service to repair the file or condense it.

    Terms & ConditionsAccessibility statement