From fc962de2b60adaa1ffa3bf70bfadc5c3d17867b3 Mon Sep 17 00:00:00 2001 From: Yannick Tivisse Date: Thu, 3 Dec 2020 09:55:31 +0000 Subject: [IMP] resource: Index calendar/resources on calendar leaves Improves performances, notably on the method https://github.com/odoo/odoo/blame/14.0/addons/resource/models/resource.py#L487 closes odoo/odoo#62791 Signed-off-by: Yannick Tivisse (yti) --- addons/resource/models/resource.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'addons/resource') diff --git a/addons/resource/models/resource.py b/addons/resource/models/resource.py index 6449665a7db..605eb8924db 100644 --- a/addons/resource/models/resource.py +++ b/addons/resource/models/resource.py @@ -990,11 +990,11 @@ class ResourceCalendarLeaves(models.Model): company_id = fields.Many2one( 'res.company', related='calendar_id.company_id', string="Company", readonly=True, store=True) - calendar_id = fields.Many2one('resource.calendar', 'Working Hours') + calendar_id = fields.Many2one('resource.calendar', 'Working Hours', index=True) date_from = fields.Datetime('Start Date', required=True) date_to = fields.Datetime('End Date', required=True) resource_id = fields.Many2one( - "resource.resource", 'Resource', + "resource.resource", 'Resource', index=True, help="If empty, this is a generic time off for the company. If a resource is set, the time off is only for this resource") time_type = fields.Selection([('leave', 'Time Off'), ('other', 'Other')], default='leave', help="Whether this should be computed as a time off or as work time (eg: formation)") -- cgit v1.2.3