Odoo Experience 2017
Odoo-Profiler: Advanced Performance Tool
Developer
Lieu : Aula Magna / Lauzelle - 05/10/2017 15:30 - 05/10/2017 15:50 (Europe/Brussels) (20 minutes)
Odoo-Profiler: Advanced Performance Tool
Moisés Augusto López Calderón
Director à Vauxoo S.A. de C.V.
Moisés Augusto López Calderón
Director à Vauxoo S.A. de C.V.

Odoo developer from 4.2 version Vauxoo Developer Manager Active member of Odoo Community Association Developer of Quality Tools like as travis2docker and runbot dockerized builds, pylint-odoo


With this talk, you will discover a module to detect performance issues related to python and/or postgresql using profiling and logging, and fixing it.  
Many issues are related to performance issues, and this presentation is important to detect the piece of code:

  • Slowest executed python method or sql query

  • Most time executed python method or sql query

This talk is a live demo where you will discover how to:

  • Force a common sql and python performance issue

  • Use the (1) Odoo-profiler module to detect it

  • Different ways to fix them (LIMIT, WHERE, INDEX, COMPLEX INDEX, STORE=TRUE, and others)

  • Fix and run again the Odoo profiler  

This talk is based on this module: https://github.com/vauxoo/odoo-profiler developed by Vauxoo