Name: [FIX] web_editor, mail, account_edi: add indexes to improve performance when deleting ir_attachment records

State: Killed finished in 229m

PR State: merged

PR Author: Roy Le

PR Author Email:

PR: #1153

Committer: Roy Le

Committer Email: roy.le@viindoo.com

Commit: 35979ea61c00c6078ad160bfbd9dfb52bbfb6b28

Description:

                                            [FIX] web_editor, mail, account_edi: add indexes to improve performance
when deleting ir_attachment records

On a DB with 15M+ attachments, deleting a single attachment takes
several seconds. Most of the time is spent on the circular `original_id`
and `message_main_attachment_id` foreign key.
                                            

Branch: 17.0

Instance ID: 0

Age:

Up-time: