Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Sale order take more tan 20 minutes to confirm with several lines

performance speed saleorder

2 Odpowiedzi

7179 Widoki

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

Emil Dela Cruz

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

Ibrahim Boudmir

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.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
After migrating from v7 to Odoo9. Now we are facing speed issue. performance speed odoo9	0 sty 17	3569
Dose large XML file impact on speed? performance xml speed	0 gru 16	3667
too slow when processing sales orders performance speed sales.order odoo16features	0 mar 24	1852
Is there any successful odoo eCommerce store for large quantity products? performance ecommerce speed 10	0 mar 19	4014
Ubuntu 18.04.2 and Odoo12 very slow after setup performance speed slow odoo12	0 lut 19	5420

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!