CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Best practice for maintenance of mailing tables
Pages: [1]

Author Topic: Best practice for maintenance of mailing tables  (Read 599 times)

nant

  • I post frequently
  • ***
  • Posts: 143
  • Karma: 4
    • Joomlapolis
  • CiviCRM version: 4.3.4
  • CMS version: Joomla 2.5.11
  • MySQL version: 5
  • PHP version: 5.3
Best practice for maintenance of mailing tables
May 02, 2014, 02:13:59 am
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?
--
Nick (aka nant from CB Team)

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Best practice for maintenance of mailing tables
May 02, 2014, 08:38:45 am
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]
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

nant

  • I post frequently
  • ***
  • Posts: 143
  • Karma: 4
    • Joomlapolis
  • CiviCRM version: 4.3.4
  • CMS version: Joomla 2.5.11
  • MySQL version: 5
  • PHP version: 5.3
Re: Best practice for maintenance of mailing tables
May 02, 2014, 08:45:45 am
Quote from: Erik Hommel on May 02, 2014, 08:38:45 am
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?
 
--
Nick (aka nant from CB Team)

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Best practice for maintenance of mailing tables
May 02, 2014, 09:08:46 am
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?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Best practice for maintenance of mailing tables
January 12, 2015, 06:02:51 pm
This was my previous analysis on this http://forum.civicrm.org/index.php/topic,28085.msg120021.html#msg120021
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Best practice for maintenance of mailing tables

This forum was archived on 2017-11-26.