odoo-performance

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.

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.

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.

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.

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.