Database Size Reduction and System Performance Improvement

To reduce the data footprint of the Simphony Transaction database and to improve overall system performance, you can change the Data Transfer Service (DTS) and data Purging job settings. For brand-new installations, default DTS and Purge job settings have been assigned to assist in controlling the amount of data that is getting stored.

After performing an upgrade, you are required to enable a new employee Roles option to grant permissions for those employees deemed responsible for editing these job settings going forward.

See the Configuring Access Privileges for Data Transfer Service (DTS) and Data Purge Job Settings section for instructions for configuring the access privilege.

Listed in the tables below, are the default DTS and data purge job settings.

Table 2-1 Default DTS Job Settings

Default DTS Job Name	Job Settings - Number of Days
Authorizations	2
Definitions	15
Journals	2
Simphony Database Purge	30
Command Module Maintenance	60
Mymicros.net Daily Aggregation	15
Time Zones	30
Labor Definitions	15

Table 2-2 Default Data Purge Job Settings

Default Purge Job Name	Job Settings - Number of Days
Activity Log	30
Audit Trail	90
Authorization Log	30
Checks	7
Client Event Log	30
CM Transaction Detail	7
Import Export	30
Journals	7
KDS Details	7
Queued Checks History	7
Signature Capture	7
Time Cards	60
Totals	7
Transaction Log	90

• Configuring Access Privileges for Data Transfer Service (DTS) and Data Purge Job Settings