PerformanceHighlight of Weekly #004

account.move attachment_id indexed

Deleting attachments, for example when assets bundles are regenerated, no longer stalls on large databases while checking this foreign key.

Versions20.0
ModulesInvoicing account
AppAccounting

Pull requests and commits

BranchPull requestCommit
20.0odoo/odoo#295124 ↗a67aacd733 ↗

Commit message

[PERF] account: index attachment_id field

On a database with many `account.move`, assets bundles cannot be re-generated
because deleting an attachment takes ages because it checks foreign keys.
This one isn't indexed.

My stack

Pick the versions and apps you run. Weekly digests, this week's table and All changes then show only what concerns you. Saved in this browser.

Versions
Apps
Modules