diff options
| author | William Henrotin <whe@odoo.com> | 2020-02-24 14:43:48 +0000 |
|---|---|---|
| committer | William Henrotin <whe@odoo.com> | 2020-02-24 16:55:02 +0000 |
| commit | 0e77b3d16a2e1e980deae3c3ea06ed44c3536d28 (patch) | |
| tree | b640bc488e68899ff7a7a055e246372c1ff0e3fe | |
| parent | fff277a4a7af950d6ec18d09d2533d95b40a2d70 (diff) | |
[IMP] stock: set index on stock_move_line.picking_id
This commit set an index on column `picking_id` of table
`stock_move_line`. Many sql requests on stock_move_line
have picking_id in their where-clause.
On a database filled with 1M pickings, reading a picking of 10
stock_move_lines is 60 times faster.
Closes https://github.com/odoo/odoo/issues/44623
closes odoo/odoo#46153
X-original-commit: a36a693733579e1e8bdaa3aa00fcc482c6299acf
Signed-off-by: William Henrotin <Whenrow@users.noreply.github.com>
| -rw-r--r-- | addons/stock/models/stock_move_line.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/addons/stock/models/stock_move_line.py b/addons/stock/models/stock_move_line.py index a0b8507e15e..c5365b87a1f 100644 --- a/addons/stock/models/stock_move_line.py +++ b/addons/stock/models/stock_move_line.py @@ -17,6 +17,7 @@ class StockMoveLine(models.Model): picking_id = fields.Many2one( 'stock.picking', 'Transfer', auto_join=True, check_company=True, + index=True, help='The stock operation where the packing has been made') move_id = fields.Many2one( 'stock.move', 'Stock Move', |