Skip to Content
This question has been flagged
wkhtmltopdfodoo
2 Replies
5789 Views
Avatar
Diego B.

Odoo v11 on my dev machine is not printing a custom pdf report with 20.000 lines of issued invoices.

I tested the printing with different amount of invoices from 1.000 to 10.000 lines with success. In fact, 10.000 lines of invoices takes about 2-3 minutes to print. Any of the subsequent tests from 11.000 to 20.000 lines of invoices doesn't print (only appears the loading message for a long time, even hours with no results).

Report has not images. Only has a table with lines, a header and footer. The test of 10.000 lines of invoices results in a report with 350 pages. But, when I test with 11.000 lines of invoices or higher it doesn't work. Printing so many data is important for us for printing entire year invoicing or VAT books for current year.

The specs of my dev machine are Core i5-3330 3.00GHz, 12 GB RAM DDR3 1333 MHz and SATA 3 hard drive.

Any suggestions on how to improve the performance of wkhtmltopdf to render tons of data?

Thanks in advance!

Avatar
Discard
Avatar
faOtools
Best Answer

Hi,

it is not about increasing performance, but about finishing long processes.

Try to increase time-outs for Odoo operations. For example, add In the configuration file:

limit_time_real = 6000

Have a look at quite old, but in the most cases topical, explanations of conf params: https://www.vionblog.com/openerp-server-conf-for-openerp-7-explained/. Here are other limits which by default might block certain operations

Avatar
Discard
Avatar
Diego B.
Author Best Answer

Thanks a lot. I'm giving it a try, but for the moment is not working. May be, is needed to set another additional parameters?

Your answer makes a lot of sense, because 10.000 lines works and takes around 2 minutes for printing. I have the feeling that with higher number of lines takes more than 2 minutes and Odoo is blocked.

Avatar
Discard
Related Posts Replies Views Activity
Where to specify the parameter of wkhtmltopdf in Odoo?
wkhtmltopdf odoo
Avatar
Avatar
Avatar
Avatar
4
Dec 19
16640
LC_CTYPE to default locale: No such file or directory ? Solved
ubuntu wkhtmltopdf odoo
Avatar
Avatar
1
Jun 25
6322
odoo.exceptions.UserError: Wkhtmltopdf failed (error code: -9). Message: b''
wkhtmltopdf odoo v14
Avatar
Avatar
Avatar
2
Feb 24
6895
Warning: "Unable to find Wkhtmltopdf on this system. The report will be shown in html." How do I resolve it? Solved
wkhtmltopdf odoo 12.0
Avatar
Avatar
Avatar
3
Oct 21
20059
SOC 1 Report
odoo
Avatar
0
Nov 25
91