Tips for maintaining your database
The ACT! Premium for Web Server administrator should monitor the size of all ACT! Premium for Web Server databases and perform routine maintenance on a regular basis to minimize database errors and optimize performance.
|
|
To complete the procedures mentioned, you must have the appropriate permissions assigned to you. For more information, see About user roles and permissions. |
Basic maintenance
Scan for duplicate records and copying or moving a contact record.
Check, repair, and re-index the database.
Save contact records you rarely use to a different database, and then remove them from the main database. Use Contact Activity lookup to locate records that are used infrequently.
If you synchronize with remote databases, review and purge your synchronization logs often.
Advanced maintenance
If your organization uses custom layouts, limit the number of users who can add fields to layouts and pick lists, have them do so responsibly, and delete any fields that are not used.
Delete outdated templates.
Decrease the size of unused custom fields. User 1 through User 10 fields are preset to 50 characters in length. If you do not use these fields, reduce the size of them.