Archives
Contributors
Re: Performance of /shop controller
El dom, 11 de abr de 2021 a las 07:31, Lorenzo Battistini <elbaddy@gmail.com> escribió:
in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.
v13 framework fixed this problem. Upgrade ASAP, that'll be the only real fix you can do.
Otherwise, try removing category filters. Those use `child_of`, which is very expensive in v12.
See https://github.com/odoo/odoo/pull/60834 for more details.
by Jairo Llopis - 09:30 - 13 Apr 2021
Reference
-
Performance of /shop controller
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!
by Lorenzo Battistini. - 09:30 - 11 Apr 2021