[7.0] Product view slow with many stock_locations

[Florent Delayen]

Hi !

With 13000 stock locations, it takes nearly 10 seconds to see the product list view, and another 10 seconds each time you click anywhere related to a product.

We analysed that bug, and saw that the fields_view_get request returns our 13000 locations and our warehouses...

This problem is related to these two fields (file: stock/product.py):

'location_id': fields.dummy(string='Location', relation='stock.location', type='many2one'),
'warehouse_id': fields.dummy(string='Warehouse', relation='stock.warehouse', type='many2one')

Does anybody knows why these fields are dummy ?

Best regards