I have an odoo instance running on a limited system, and it seems some of the people using it are trying to perform an inventory adjustment with a product category that contains 2100 products.

The moment that the user modifies the quantity of 1 item, basically the odoo instance crashes, the connection times out and gets reestablished. CPU resource utilization usage in python spikes to 90%. When I turn sql debugging on in odoo, it looks I'm seeing about 2100~ stock quant select queries every time I change the quantity of the products.

Can anybody recommend me some optimisations I could perform here? It's only 2000 products so I think it's more of a problem with either inefficient or badly written code.