It is possible for SMS Epress to become very slow due to database fragmentation, usually the application will warn you that there is a problem and compacting may be needed. But if the Audit Save threshold is set excessively high 100000 this warning may not appear. In very dynamic system; many programming activities each day; a high value of Audit Save may abscure a fragmentation problem to the point that the application is so slow it may be practically unusable.
Solution: Check the Audit Save threshold adjust to a more reasonable value 5,000 - 10,000 this should force the algorithm to detect the fragmentation and present the warning to compact the database.
More frequent archiving of audits will also help the efficiency of the database.
Customers should evaluate the Site management strategy to see if they can minimize quantity of required programming tasks.
Also, If you are using a pda to program and you get the hourglass while trying to generate program files you will need to delete the door and audit files out of the The export folder. They are files with the extension >DO1, DO2, ect.../ .Ao1, Ao2, ect...
DISCLAIMER:
INFORMATION PROVIDED THROUGH THIS SITE IS PROVIDED TO YOU AS IS WITHOUT ANY EXPRESS REPRESENTATIONS OR WARRANTIES
OF ANY KIND, AND WE MAKE NO REPRESENTATION OR WARRANTY THAT THIS SITE(OR ANY INFORMATION PROVIDED IN RESPONSE TO
YOUR INQUIRY), WILL BE ACCURATE, COMPLETE, OR ERROR-FREE.
YOU AGREE THAT YOU MUST EVALUATE ALL INFORMATION AND RESPONSES, AND THAT YOU BEAR ALL RISKS ASSOCIATED WITH, THE
USE OF THIS SITE, INCLUDING ANY RELIANCE ON THE ACCURACY,COMPLETENESS, OR USEFULNESS OF ANY INFORMATION OR MATERIALS
MADE AVAILABLE THROUGH THIS SITE.