Contributors mailing list archives

contributors@odoo-community.org

Avatar

Performance of /shop controller

by
TAKOBI s.r.l., Lorenzo Battistini.
- 11/04/2021 07:26:14
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!

Follow-Ups