Contributors mailing list archives

contributors@odoo-community.org

Avatar

Re: Performance of /shop controller

by
Vauxoo, Moisés López Calderón
- 11/04/2021 07: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 <elbaddy@gmail.com> 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!

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

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

Reference