Too many old activity records
Having too many rows in the Activity Table of your Kentico Xperience Online Marketing database indicates that your site either has a very high level of activity, or you are not following best practices of cleaning up stale activity records. This can lead to a very high level of performance degradation if not dealt with.
It is usually unnecessary to keep records for long periods of time and old records can be removed without hindering your marketing efforts. The number of activity records stored by the system is determined by the number of contacts stored.
Constant Care for Kentico will ensure the number of old activity records is no more than 0 (default)
You can manage your settings for this checkup in the Constant Care for Kentico admin settings.
Verifying The Check
To view and manage the activities tracked by your site you can navigate to the Contact Management Application and view the Activity Log tab.
You can also review your settings to see what types of activities are being tracked by navigating to the Settings Application and then to On-line marketing > Contact Management > Activities.
In order to limit the length of time Contacts are stored (and, thereby, Activities) you can navigate to the Settings Application and then to On-line marketing > Contact Management > Contacts. We recommend not keeping contact and activity records for more than a year.
You can also refer to the documentation for the om-contact-too-many-records check.
Changes to your site should only be made by an experienced Kentico Xperience developer. If you need assistance in making these changes please reach out to the Toolkit For Kentico team to be connected with a Kentico Xperience partner.