Quote very slow on save

[petec81]

Module

Sale Order Archive

Describe the bug

after installing the module the sales model turns very slow, when i click "save" on the new quote it takes 3 minutes to save it

To Reproduce

Affected versions: 15

Steps to reproduce the behavior:

1. created the order without the module installed (2 seconds)
2. installed the module
3. created the order with the module installed (3 minutes)

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here. (e.g. OS, Python version, ...)

[legalsylvain]

Hi. Interesting problem.
Could you mention the number of sale.order / sale.order.line you have in your instance ?
Could you log slow SQL queries and display the result here, to try to understand the source of the slowdown?

thanks !

[pedrobaeza]

For me it sounds very weird that the active field provokes that slowness. Please uninstall the module and check again the speed.

[petec81]

I have 8799 sale orders in total

here is the sql query in a video. I takes over a minute to save a sale order with only 1 line item. If the module is not installed then its instant.

https://drive.google.com/file/d/1UicJ1wL4etg3y3kN_s91o5kYbXoYETq8/view

[petec81]

here is another video showing the module uninstalled and the time it takes after clicking save

https://drive.google.com/file/d/1_0c2CbnQCoOlHGr-J2BLuJ9T4llMff74/view

[pedrobaeza]

I see several customizations (including Odoo studio) in the SQL trace. Please try the module in a fresh DB to see if you have the same problem.