Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Re: Performance of /shop controller
by
Sunflower IT, Tom Blauwendraat
If you use profiler module,
Port this and measure only /shop request
https://github.com/OCA/server-tools/pull/1986
Or use this directly with workers=0 in controlled environment:
https://github.com/OCA/server-tools/pull/1369
Then you can know which python function calls the sql_db and which ORM call was it, and know more about what generates the offending SQL.
And of course follow Moises advice in order to actually get the offending SQL
Port this and measure only /shop request
https://github.com/OCA/server-tools/pull/1986
Or use this directly with workers=0 in controlled environment:
https://github.com/OCA/server-tools/pull/1369
Then you can know which python function calls the sql_db and which ORM call was it, and know more about what generates the offending SQL.
And of course follow Moises advice in order to actually get the offending SQL
Apr 11, 2021 09:31:56 Lorenzo Battistini <elbaddy@gmail.com>:
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
