Hello

We have an Odoo 13 site running on substantial dedicated hardware with the application on one machine and the database on another with a dedicated 1 GB line between them and performance is abysmal.

Attempts to find the problem revealed no shortage of memory, CPU power or network speed. The disks are all SSD.

What was found was that 'wget'ing one page in a test environment on the same hardware as production, with production data took 46 seconds and during this time the database was queried 3600 or so times. These database queries happened in sequence and they all completed in milliseconds.

Can one infer from that that Odoo is single threaded for each request?

As an aside when 'wget'ing that same page 16 times (number of Odoo processors)  in parallel, they all complete in just over 50 seconds each at the same time after using about half the CPU on the Odoo servers and 73% of the CPUs on the database servers for the duration of the 50 seconds. The machines are strong enough one must conclude.

Yes, there are quite a few non Odoo native addons in the system.

They are there for a good reason so the solution is not to remove them but rather find a way to get the html built a lot quicker. We are engaging with the partner to optimize these knowing very well that this will only reduce some of the delay.

Desperately awaiting any insights, suggestions, recommendations, anything...:-)

Thank you