Odoo 14E - we're finding that when clicking Create on the Manufacturing Orders screen, the form takes around 3-4 minutes to load. This is repeatable every time. It's gradually become worse as our total number of products in the database has increased (currently 250k).
As far as I'm aware we've not made any customisations to the manufacturing module (luckily we don't need to use it very often!)
Any suggestions on how to begin troubleshooting this? Every other aspect of Odoo is working quickly and the server is 16C/64GB/NVMe, no other problems. Once you've created the manufacturing order it's quick to save, build, etc - the delay just seems to be when Odoo loads the form. Making a BOM works fine.
The delay feels about the same length of time as if we make Odoo calculate the virtual_available forecasted quantity field for every product in the database, but I can't see why it would be doing that.
Hi Daniel
Could you set the log level to debug, and upload logs when creating orders.
Regards
Eric Li