Report performance ODT vs ODS

[Oscar Alvarez]

Hi devs,

I want to share with yours, a "new" discovery about the performance on
Tryton when it render a report in format odt vs ods, for this case:

1. The size file in ods report is 58% less than odt, of course both
files has same quantity data and the similar design (See files attached)

2. The speed of render each report is:

odt -> 39.0 seconds
ods -> 32.3 seconds

To create an ods is 17% faster than odt. This values are important when
in the accounting to exist high number of account moves and move lines.

The report template used is very similar to general ledger.

I thinking about if open a new issue (features), for to migrate some
reports (not all) to ods format instead odt.


Oscar Alvarez

[Cédric Krier]

This is known since long ago: https://bugs.tryton.org/issue1399
But I don't think we must change the default format. ODS is not really a
good format for layout while ODT is designed for that (that's why it is
slower).
About the performance issue of report like General Ledger, for me, it
makes no sense to create an ODT nor ODS of it if you have a lot of data
because it is any way useless. Indeed improving the situation is the
goal of https://bugs.tryton.org/issue4996 where it is not required to
use the Report to have access to the data and also CSV export could be
used.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/