Compressed Database: What does it really do?
October 2nd, 2008 by Sharon BlakesleeThe utility found in the Administrations module is designed to reduce the size of the database. This is not for the weak at heart. Depending on the size of the database to be compressed it could take quite some time to run. The compress utility can be run at anytime but requires exclusive use of the database. It does not remove any data, but it does remove the empty pages in the tables and also re-indexes the file to make it more efficient. In other words, the SQL script is run to reclaim space that was allocated to the database but not used.
Sage recommends that you at least run this utility when the database gets to around 1.5GB. Run all data integrity checks and make a backup of the database before using the compress
feature. After compressing the database run data integrity checks again. Check in with your IT folks to see what size the MIP database is and to see if your MIP database might need to be compressed. We recommend your database administrator run this utility at a scheduled time.
