After upgrading to Odoo 17, I’ve noticed a significant slowdown in loading times, especially in the Sales and Inventory modules. Has anyone else faced this issue? Any recommendations for optimization?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Účtovníctvo
- Sklady
- PoS
- Project
- MRP
This question has been flagged
1
Odpoveď
854
Zobrazenia
✅ 1. Review Server Specifications:
Ensure the server meets the minimum recommended specs:
- CPU: 4 cores minimum (8+ preferred for heavy usage)
- RAM: 8GB+ recommended
- Disk: SSD with high IOPS
- PostgreSQL: At least v13 or higher
✅ 2. Check Custom Modules:
Outdated custom modules from older versions can:
- Slow down views and reports
- Break lazy loading
- Cause inefficient SQL queries
Use the Odoo Profiler (Developer Tools > Performance) to identify bottlenecks.
✅ 3. Enable and Tune Caching:
Use ir.config_parameter to enable:
- QWeb caching
- Asset bundling
- DB and HTTP caching
Activate --workers in production (for WSGI multiprocessing) instead of using --dev mode.
✅ 4. Optimize PostgreSQL Configuration:
Fine-tune PostgreSQL using:
- work_mem = 64MB
- shared_buffers = 25%-40% of RAM
- effective_cache_size = 70%-80% of RAM
- Install pg_stat_statements to monitor heavy queries
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Zobrazenia | Aktivita | |
|---|---|---|---|---|
|
2
máj 25
|
519 | ||
|
2
máj 25
|
1270 | ||
|
1
máj 25
|
200 | ||
|
0
apr 25
|
410 | ||
|
0
apr 25
|
8 |
Did you manage to fix the problem?
I've been experiencing slowness on version 18 since the upgrade