Contributors mailing list archives
Re: Performance of /shop controllerby
Vauxoo, Moisés López Calderón
It could be a lot of things
I was realized that computing prices is heavy.
But prefetching tables too as
Missing indexes and so on.
There are fixes using LRU cache in newer versions but if you have detected that queries are slow you can try getting the postgresql log in order to analyze it
On Sun 11 Apr 2021 at 2:31 a.m. Lorenzo Battistini <firstname.lastname@example.org> wrote:
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!