Root Causes & Solutions for Odoo Hanging on Large Sale Orders

1.  Use Pagination or Limit Records
   • Avoid loading all Sale Orders at once.
   • Enable pagination in list/tree views (limit in XML views or filters).
2.  Optimize Filters and Domains
   • Avoid overly complex domain filters.
   • Use indexed fields in your search criteria.
3.  Disable Unnecessary Related Fields
   • Computed/related fields (e.g., customer balance or custom pricing) can cause delays—load them only when needed.
4.  Enable Lazy Loading for Smart Buttons
   • Defer loading of related records (e.g., invoices, deliveries) until user clicks.
5.  Database Optimization
   • Add proper indexes on frequently searched fields (partner_id, date_order, state).
   • Run VACUUM ANALYZE periodically (PostgreSQL).
6.  Log Slow Queries
   • Enable PostgreSQL slow query log and Odoo --dev=all to trace performance issues.
7.  Split Data by Archiving
   • Archive or auto-archive old sale orders not accessed frequently.
8.  Server Performance Scaling
   • Allocate more RAM/CPU to Odoo and PostgreSQL.
   • Use Odoo's workers in multi-threaded mode (not --dev=all in production).
9.  Offload Reporting
   • Move reporting-heavy logic into scheduled jobs or dashboards instead of loading in the main view.