Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
performanceaccountingsystem
1 Odgovori
1049 Prikazi
Avatar
Nyan Min Htet

I am facing performance issues when trying to print custom accounting reports to Excel. These reports cover a significant amount of data, typically spanning 6 months. Despite having the server running on 2 workers in Odoo.sh, the server occasionally crashes during this process.

I am unsure if I should focus on optimizing the code to handle the export process more efficiently or if there is a better approach for viewing and handling these accounting reports.

Could anyone share insights or best practices on how to handle large datasets in accounting reports? Should I look into code optimizations, or are there alternative methods for efficiently accessing and exporting these reports?

Thank you for your advice!

Avatar
Opusti
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


Your server crashes because generating large Excel reports synchronously overloads worker memory and CPU. To fix this, focus on two solutions:


1- Optimize the Code: Replace slow ORM calls with efficient raw SQL queries in the report's data-fetching method. This lets the database handle the heavy lifting.


2- Change the Process: Implement asynchronous reporting. Use the queue_job module to generate reports in the background. Users get a notification with a download link when the file is ready, preventing server timeouts and crashes.


For immediate relief, encourage users to filter data and view reports as PDFs before exporting to Excel. The long-term, most effective solution is to adopt asynchronous processing.


Hope it helps

Avatar
Opusti
Nyan Min Htet
Avtor

Thank you for answering queue_job might be the answer I am looking for

Related Posts Odgovori Prikazi Aktivnost
Payment reminder email PDF invoice is not getting attached
accounting system mail
Avatar
Avatar
2
okt. 25
837
How to enable defered expenses & revenues?
development accounting system finance
Avatar
Avatar
1
sep. 25
1304
Server Slowness Solved
performance accounting function logistic
Avatar
Avatar
Avatar
2
maj 25
1522
I found a small typo in the Odoo 19 Chart of Accounts — and it made my day 😆 Solved
accounting
Avatar
Avatar
Avatar
2
nov. 25
178
Invoice-Digitize-Individual Line Items
accounting
Avatar
Avatar
1
nov. 25
437