diff options
| author | Richard Mathot <rim@odoo.com> | 2020-09-16 13:35:02 +0000 |
|---|---|---|
| committer | Richard Mathot <rim@odoo.com> | 2020-09-23 11:48:29 +0000 |
| commit | 68b8f1eae653d454538c1552c2553a7d7f06185e (patch) | |
| tree | 8524b14550b73148a04544af60805e877d2775dd /addons/web/static/src/js/fields/basic_fields.js | |
| parent | 137bc1098dc66f67eda181d0062327dd570ead01 (diff) | |
[FIX] mrp: more Voodoo magic
It appears that if you update a record more than once in the same
PostgreSQL transaction, PostgreSQL is going to re-check all the
constraints on the table.
** THIS IS THE PART WHERE THE BLACK MAGIC HAPPENS **
We combine the setting of the default value of stock.move.unit_factor in
the same UPDATE query to avoid the constraint re-check; it saves
approximately 60% of the SQL running time in my case.
** ... AND NOW YOU CAN SAY: WHAT THE F...?! **
Thanks to @rco-odoo for the tip; he knows it from the wise @nseinlet.
X-original-commit: 8e47e2f605309c8ed0d5509f7bb070528d8f32c4
Diffstat (limited to 'addons/web/static/src/js/fields/basic_fields.js')
0 files changed, 0 insertions, 0 deletions
