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
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
We've seen this quite a bit after upgrades, especially with Sales and Inventory. In most cases, it's the PostgreSQL backend causing the slowdown. Things like missing indexes or slow queries are usually the culprits.
Feel free to DM me if you want to troubleshoot it together.
✅ 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
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng kýBài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
---|---|---|---|---|
|
1
thg 6 25
|
491 | ||
|
3
thg 5 25
|
2079 | ||
Install your own modules in Odoo
Đã xử lý
|
|
2
thg 7 25
|
1160 | |
|
2
thg 5 25
|
2029 | ||
|
1
thg 5 25
|
901 |
Did you manage to fix the problem?
I've been experiencing slowness on version 18 since the upgrade