diff options
| author | Olivier Dony <odo@odoo.com> | 2018-07-03 17:11:20 +0200 |
|---|---|---|
| committer | Olivier Dony <odo@odoo.com> | 2018-07-04 10:16:38 +0200 |
| commit | 43e4d63d069e16e64a768ef4742a5d4fca177f0c (patch) | |
| tree | 1f5d19ef3b8272593d6eb80d721e4b7797240315 /addons/mass_mailing/models | |
| parent | a5edf6e0f3f08f8f10043f77c9a4ee653af64b18 (diff) | |
[IMP] mass_mailing: add missing indexes
These two columns are used to compute the mailing statistics, to be
displayed in the kanban dashboards. Adding them makes the dashboards
a lot faster on large databases (e.g. a few milliseconds instead of
several seconds)
Diffstat (limited to 'addons/mass_mailing/models')
| -rw-r--r-- | addons/mass_mailing/models/mass_mailing_stats.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/addons/mass_mailing/models/mass_mailing_stats.py b/addons/mass_mailing/models/mass_mailing_stats.py index 91648f22d35..0a095943f99 100644 --- a/addons/mass_mailing/models/mass_mailing_stats.py +++ b/addons/mass_mailing/models/mass_mailing_stats.py @@ -27,11 +27,11 @@ class MailMailStats(models.Model): model = fields.Char(string='Document model') res_id = fields.Integer(string='Document ID') # campaign / wave data - mass_mailing_id = fields.Many2one('mail.mass_mailing', string='Mass Mailing') + mass_mailing_id = fields.Many2one('mail.mass_mailing', string='Mass Mailing', index=True) mass_mailing_campaign_id = fields.Many2one( related='mass_mailing_id.mass_mailing_campaign_id', string='Mass Mailing Campaign', - store=True, readonly=True) + store=True, readonly=True, index=True) # Bounce and tracking scheduled = fields.Datetime(help='Date when the email has been created', default=fields.Datetime.now) sent = fields.Datetime(help='Date when the email has been sent') |