Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
1 Răspunde
440 Vizualizări

Hi,

I’m using Backend is Odoo 13.0 Community Edition and a mobile app.

Issue:

Odoo hangs when trying to access the Sale Order menu, but only when the sale order table exceeds 100,000 rows. With fewer rows, everything works perfectly.

System Configuration:

  • Server: 4 CPUs, 8GB RAM, 120GB SSD
  • Average concurrent users: ~15 (via mobile app)

Details:

  • I can log in and view other menus (e.g., Store, Product) without issues.
  • The problem occurs only when trying to load Sale Orders with >100,000 rows.

Has anyone encountered this issue? Could it be related to server performance, indexing, or Odoo’s limitations? Any guidance on troubleshooting or potential fixes would be greatly appreciated.

Regards!

Imagine profil
Abandonează
Autor

Hi Dhrumi,

Thank you for your detailed response.

Based on my current server configuration (4CPU, 8GB RAM, 120GB SSD), if everything is optimized correctly (database indexing, load balancing, etc.), what would be the approximate maximum record limit that Odoo 13.0 Community can handle smoothly for the Sale Order model (I'm NOT doing customize much for Sale Order so please be aware that default Sale Order)?

I’d like to understand the system’s scalability limits to plan for potential optimizations or upgrades.

Thanks again for your help!

Cel mai bun răspuns

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.

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
0
iul. 25
1940
1
feb. 25
1119
2
iul. 24
1730
1
iun. 24
1518
0
dec. 23
1144