Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
1278 Zobrazení

Dear, I have been facing a problem for 3 days and I have not found a solution. The same thing is that when I want to validate a supplier reception, internal supply reception, an internal transfer, Expedition or POS order, the time is excessive. The maximum number of lines is 56 which cannot be completed and the minimum is 3 lines which takes 2.5 minutes. The same thing happened to someone, how could they solve it?

Avatar
Zrušit
Autor


Hello Rakesh.

We have already been evaluating many of these possible solutions.

Server we have 12 workers and our own server.

almost all of these solutions were tested.

Generally we are not doing many operations simultaneously and tests were carried out at night where we do not have users operating and we only worked on a single document, which unfortunately did not have the expected result.

Nejlepší odpověď

Hello Omar 
That was If and but cases but check the below solution 

Solutions

1. Optimize Server Performance

  • Upgrade Resources: Increase CPU cores, RAM, and disk speed (use SSDs).
  • Load Balancing: If multiple users are active, consider setting up a load-balanced environment.

2. Review Custom Modules

  • Audit custom modules or workflows for inefficiencies in their code.
  • Optimize Python code and SQL queries in customizations.

3. Index the Database

  • Add appropriate indexes to frequently queried tables (e.g., stock moves, stock picking).
  • Analyze slow queries using Odoo's logs or database tools.

4. Batch Processing

  • For operations with multiple lines, break them into smaller batches.
  • Validate smaller batches instead of large operations to reduce processing time.

5. Disable Unnecessary Features

  • Temporarily disable workflows like automatic reordering rules during bulk validations.

6. Technical Auditing

  • Use Odoo's Profiler or log debugging mode to pinpoint bottlenecks during validations.

7. Upgrade Odoo Version

  • Ensure you're on the latest stable version of Odoo, as newer versions typically include performance improvements.

8. Optimize Third-party Services

  • If you use external integrations (e.g., payment gateways, shipping APIs), ensure they are not causing delays during validation.

9. Parallel Processing

  • If you regularly process operations with many lines, consider scripting custom parallel processing to reduce load times.
Avatar
Zrušit
Autor Nejlepší odpověď

I have version 16

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
čvn 23
2705
0
čvc 24
1841
0
kvě 24
1520
1
bře 24
2125
Out of Stock Vyřešeno
4
úno 24
5153