Contributors mailing list archives

Browse archives


Re: Performance of /shop controller

Vauxoo, Moisés López Calderón
- 11/04/2021 09:38:23
It could be a lot of things

I was realized that computing prices is heavy.
But prefetching tables too as
 - website.user_id.partner_id.lang
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 <> 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/ takes most of the time.

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


Post to:

Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter: @moylop260
hangout: - Odoo Gold Partner
Twitter: @vauxoo