Ashwani Kumar Yadav Get in touch
← All posts

Seven Areas to Review When Optimizing Odoo Modules

Notes on computed fields, concurrency, scheduled jobs, tracking, and ORM performance.

Enterprise Odoo performance often involves more than changing individual queries. These are seven areas I review:

1. Check when computed fields are evaluated and whether precomputation is appropriate.
2. Review transaction boundaries and record locking for work that can run concurrently.
3. Break long scheduled jobs into smaller batches that can finish within worker limits.
4. Measure the cost of chatter and tracking on large writes before changing tracking behavior.
5. Flush pending ORM changes before SQL needs to read them, and use the appropriate ORM cache invalidation after direct SQL writes.
6. Choose tracking that matches the auditing requirements of high-volume records.
7. Process large datasets in batches and measure the effect on runtime and memory.

API behavior and the best implementation can vary by Odoo version and workload.