Hi guys,
A few years ago I posted a question about deleting marketing data: https://doc.dynamicweb.com/forum/cms-standard-features/cms-standard-features/deleting-newsletter-data
I am now faced with the same challenge and have a few more questions:
1. My EmailMessage table contains about 40GB (!) worth of data. I ran the following query:
select COUNT(*) from EmailMessage WHERE MessageId IN
(
select EmailMessageId from EmailMarketingEmail
)
which gave me just a few records (350+ out of 450.000 or so)
Are the others orphaned rows I can just delete? Or can I even wipe out the entire table?
2. The customer would like to see the (summary) results of old emails (up to a certain date). Do I need any data in the following tables for that:
EmailRecipient
EmailMessageTag
EmailAction
I guess I do, as none of the results are aggregated anywhere, are they?
Imar
