Sage 100

Client is on v4.5.  I plan on purging history from IM and SO history files that have 4 files (up through .003).  Sage KB article for purging Item History (38730) recommends rebuilding keys to reduce space after the purge.

@Alnoor Cassim provided a description of what  Rebuilding does vs Optimize some time ago.  My question is: under these circumstances, will Optimize be sufficient, or should I do a full Rebuild?  Also, do they take the same amount of time?  Or will Optimize be faster?​

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

If the purpose is strictly to recover disk space then Optimize. It's sole purpose is to create a brand new empty file/table based on the data dictionary, then copy all records from old file to new file 1 record at a time. In the end the old file gets erased and new file gets renamed to the old file. This method results in no empty space / bloat.

I don't know if it runs faster or slower than regular Rebuild. I do know that if there is a history of data corruption or needing to Rebuild these IM and SO history files in the past, the more prudent option is to Rebuild instead of Optimize.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Thanks, Alnoor.  I think I'll err on the side of caution and Rebuild.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 12-11-2019 01:28
From: Alnoor Cassim
Subject: Rebuild Key Files or Optimize after transaction history purges (v4.5)

If the purpose is strictly to recover disk space then Optimize. It's sole purpose is to create a brand new empty file/table based on the data dictionary, then copy all records from old file to new file 1 record at a time. In the end the old file gets erased and new file gets renamed to the old file. This method results in no empty space / bloat.

I don't know if it runs faster or slower than regular Rebuild. I do know that if there is a history of data corruption or needing to Rebuild these IM and SO history files in the past, the more prudent option is to Rebuild instead of Optimize.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------