Contributors mailing list archives

Browse archives


Re: Performance of /shop controller

Sunflower IT, Tom Blauwendraat
- 11/04/2021 10:48:58
If you use profiler module,

Port this and measure only /shop request

Or use this directly with workers=0 in controlled environment:

Then you can know which python function calls the sql_db and which ORM call was it, and know more about what generates the offending SQL.

And of course follow Moises advice in order to actually get the offending SQL

Apr 11, 2021 09:31:56 Lorenzo Battistini <>:

Hi all,

in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.

We already cache \/web\/(static|image|content)\/ in nginx and installed website_js_below_the_fold, but odoo server is the bottleneck at the moment.

I profiled these requests with py-spy and noticed that execute function (odoo/ takes most of the time.

Did anybody analyze these queries and have experience or modules to share?


Post to: