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

State: Killed finished in 199m

PR State: merged

PR Author: Roy Le

PR Author Email:

PR: #1152

Committer: Roy Le

Committer Email: roy.le@viindoo.com

Commit: b7b8e0dec213168cdf14fc49aeb1cd6cf482a9f1

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: 16.0

Instance ID: 0

Age:

Up-time: