Best practice for maintenance of mailing tables

[nant]

After bulk mailings there are various tables that tend to grow quickly.

Such tables are:

civicrm_mailing_event_delivered
civicrm_mailing_event_queue
civicrm_mailing_recipients

I am not sure how important it is to keep these growing and in fact what I would be loosing if I decided to start pruning these.

Is there some resource that can help me decide?

[Erik Hommel]

As far as I know:

• civicrm_mailing_event_delivered holds the data of the mailing event when a mailing is delivered to a recipient
• civicrm_mailing_event_queue holds a mailing event (an event is for example if a recipient opens a link, it is delivered or it bounces
• civicrm_mailing_recipients holds the contacts that received the mailing

The data in there depends on your mail settings, and the importance depends on what you or your users expect to be able to report on?
[/list]

[nant]

As far as I know:

• civicrm_mailing_event_delivered holds the data of the mailing event when a mailing is delivered to a recipient
• civicrm_mailing_event_queue holds a mailing event (an event is for example if a recipient opens a link, it is delivered or it bounces
• civicrm_mailing_recipients holds the contacts that received the mailing

The data in there depends on your mail settings, and the importance depends on what you or your users expect to be able to report on?

Thanks for your reply.

Not sure your second bullet is correct as the structure does not seem to agree with you.
The civicrm_mailing_event_queue table has following columns: id, job_id, email_id, contact_id, hash, phone_id

SO I guess the question is what is affected?

Mailer reports?

How about activity info about mailing in the activity tab of a contact?
 

[Erik Hommel]

The mailer reports will definitely be affected. The activity on the contact itself not, as it is created separately in the civicrm_activity table as far as I know. But some drilling information from that activity might be gone.
I would recommend removing some on a test environment and check what the effect is?

[Eileen]

This was my previous analysis on this http://forum.civicrm.org/index.php/topic,28085.msg120021.html#msg120021