Skip to Content
This question has been flagged
performancespeedsaleorder
2 Respostes
7151 Vistes
Avatar
Mariano Dangelo

In odoo v9,  I'm having a problem with long lines sale order, sales order over 500 lines hang outs and with a litle luck finish confirming the order after 20 minutes computing, after that on stock.picking validation, it also take too long...
Server hardware dell power edge, xeon 16 core 16 gb ram.

Is odoo capable of handling long lines sales orders ?

Postgres config file:

# DB Version: 9.6
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 8 GB
# CPUs num: 4
# Data Storage: hdd

max_connections = 200
shared_buffers = 2GB
effective_cache_size = 6GB
maintenance_work_mem = 512MB
checkpoint_completion_target = 0.7
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 4
effective_io_concurrency = 2
work_mem = 5242kB
min_wal_size = 1GB
max_wal_size = 2GB
max_worker_processes = 4
max_parallel_workers_per_gather = 2

odoo config file:

workers = 8 
limit_memory_hard = 3355443200
limit_memory_soft = 1258291200
limit_request = 8192
limit_time_cpu = 600
limit_time_real = 1200
max_cron_threads = 1

Avatar
Descartar
Avatar
Emil Dela Cruz
Best Answer

Hi! We're you able to fix this problem? I am now experiencing this very same issue.

Avatar
Descartar
Avatar
Ibrahim Boudmir
Best Answer

Hi, 
First of all, You need to check what makes the confirmation process so slow. 
For that, you may refer to a very useful module developed by Smile Open source called smile_perf_analyzer 

https://github.com/Smile-SA/odoo_addons/tree/9.0/smile_perf_analyzer
You can refer to its 11.0 version for Configuration as it is well explained there. 
P.S : some extra tips for your case:

1- User : choose the user who does the action of order confirmation     

2- In Methods, add the confirmation function. 

3- models : sale order

4- select Profile python methods and SQL requests in order to view all the changes that happen while confirming your order.

Now, log in with the user mentioned, confirm your order, Check the logs that the modules mentions.

You can get the number of queries that are being called. You 'll get hints of what really makes your process so slow and probably get ideas to improve your code.

Waiting to hear from you.
Thumps up if this helps.
Regards.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
After migrating from v7 to Odoo9. Now we are facing speed issue.
performance speed odoo9
Avatar
0
de gen. 17
3527
Dose large XML file impact on speed?
performance xml speed
Avatar
0
de des. 16
3643
too slow when processing sales orders
performance speed sales.order odoo16features
Avatar
0
de març 24
1797
Is there any successful odoo eCommerce store for large quantity products?
performance ecommerce speed 10
Avatar
0
de març 19
3957
Ubuntu 18.04.2 and Odoo12 very slow after setup
performance speed slow odoo12
Avatar
0
de febr. 19
5345