diff options
| author | Julien Legros <jle@odoo.com> | 2018-03-05 10:56:56 +0100 |
|---|---|---|
| committer | Julien Legros <jle@odoo.com> | 2018-03-05 12:12:56 +0100 |
| commit | d8014a5a1e72af910a0b0027e18f67a558ee1d94 (patch) | |
| tree | cec56534a92b7636c35599b21edb7d0c725d9b2e /addons/web/static/src/js/views/basic/basic_controller.js | |
| parent | f7307d64b88f641bd12124f9b08c16835c53cad7 (diff) | |
[IMP] project: add 3 indexes to project_task
This commit adds 3 indexes targeting project_task which are not only
useful in regular RW use cases, but help tremendously when deleting
tasks.
In a production scenario, deleting a single task record went from 685ms
to 5ms.
Equivalent queries for an existing database:
CREATE INDEX account_analytic_line_task_id_index ON account_analytic_line(task_id);
CREATE INDEX project_task_parent_id_index ON project_task(parent_id);
CREATE INDEX sale_order_line_task_id_index ON sale_order_line(task_id);
Diffstat (limited to 'addons/web/static/src/js/views/basic/basic_controller.js')
0 files changed, 0 insertions, 0 deletions
