Performance Issue with Custom Accounting Reports Export to Excel

Question

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 pr

Cybrosys Techno Solutions Pvt.Ltd · Accepted 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 rea

Post Terkait	Replies	Tampilan
How to enable defered expenses & revenues? development accounting system finance	1 Sep 25	924
Server Slowness Diselesaikan performance accounting function logistic	2 Mei 25	1191
Importar pagos clientes y proveedores accounting	2 Sep 25	97
How can we upload the Opening Balances. [Expenses, Asset, Income, Liability] Diselesaikan accounting	1 Sep 25	164
Customer Statements Diselesaikan accounting	5 Sep 25	1110

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!