odoo-performance

Identify and fix Odoo performance bottlenecks with optimization techniques for versions 17/18/19.

1|1|Updated Apr 12, 2026

Search Tags:#performance #odoo #indexes #n+1 #bulk-operations #ormcache #search_fetch

Ready to run

npx skills add https://github.com/halim-23/odoo-dev-plugin --skill odoo-performance

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: odoo-performance
Source: https://github.com/halim-23/odoo-dev-plugin/tree/main/skills/odoo-performance
Command: npx skills add https://github.com/halim-23/odoo-dev-plugin --skill odoo-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Optimizes Odoo performance by identifying bottlenecks and applying proven tuning techniques across Odoo 17, 18, and 19 (CE & EE).

Core Features & Use Cases

N+1 query detection and fixes
Prefetching and search_fetch for efficient recordsets
ORM caching with @tools.ormcache for expensive lookups
Indexing strategies and performance considerations
Bulk operations (batch create/write) to scale data processing
Raw SQL for heavy aggregations and reports
Cron chunking and tuning to avoid timeouts
List view and compute field optimization (store vs non-store)

Quick Start

Explain a step-by-step Odoo performance optimization plan for versions 17/18/19 CE/EE.

Frequently Asked Questions about odoo-performance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I detect and fix N+1 queries in Odoo?▼

Fix N+1 queries in Odoo by applying ORM prefetching and the search_fetch method to load related records efficiently. This reduces database roundtrips and improves view loading performance.

What is the best way to optimize Odoo ORM performance for large datasets?▼

Optimize Odoo ORM performance for large datasets by using bulk operations for batch create/write, applying raw SQL for heavy aggregations, and implementing @tools.ormcache for expensive lookups.

Does this Odoo performance optimization guidance apply to version 17 Community Edition?▼

Yes, the performance optimization guidance applies to Odoo 17, 18, and 19 across both Community and Enterprise Editions. It provides version-specific ORM tuning, indexing strategies, and benchmarks to validate improvements.

How do I tune Odoo cron jobs to avoid timeouts on heavy workloads?▼

Tune Odoo cron jobs to avoid timeouts by implementing cron chunking to split large data processing tasks into smaller batches. This prevents memory exhaustion and ensures scheduled actions complete successfully.

When should I use stored compute fields versus non-stored fields in Odoo?▼

Choose stored compute fields in Odoo when reading data frequently across list views to avoid real-time recalculations. Use non-stored fields when data changes rapidly to ensure accuracy without heavy database write overhead.