Contributors mailing list archives

contributors@odoo-community.org

Avatar

Re: Performance of /shop controller

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

Port this and measure only /shop request

https://github.com/OCA/server-tools/pull/1986

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

https://github.com/OCA/server-tools/pull/1369

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 <elbaddy@gmail.com>:

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/sql_db.py) takes most of the time.

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

Thanks!

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference