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: