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.
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.
Not sure what to do?
If you are ever unsure about making changes to your site, we encourage you to reach out to your
Kentico Xperience Gold Partner. If you do not have a partner,
then feel free contact the Constant Care For Kentico team to get connected
with an expert