Friday, June 11, 2010

SQL Archive Utility Added

A SQL Archive Utility has been added to the Toolbox Module of ZP SQL This utility gives users an easy way to archive unused records from the Building Inspection Details database and Building Fee Details database. Because of the way lists from the maintenance databases are copied over when new Building permits are created, it is easy to accumulate inspection and fee detail records that are never actually used. Removing these excess records, especially if there are thousands of them, can help increase the response speed of the Building Module. The Archive Utility automates the removal process while still providing a way to retain the records until you are ready to permanently delete them.

No comments:

Post a Comment