diff options
| author | Nicolas Seinlet <nse@openerp.com> | 2018-06-06 10:59:07 +0200 |
|---|---|---|
| committer | jem-odoo <jem@openerp.com> | 2018-08-21 13:28:42 +0200 |
| commit | e8f01b94ce8f4aeed7e573821bcfd73d6c20024c (patch) | |
| tree | 296f14e8efd2bbd72363ada8801691e17b9a045a /addons/mail/static/src | |
| parent | 43e29e5d8fd059f42b3543f3f6ee5e88f68f0c52 (diff) | |
[IMP] sale,sale_*: denormalize sale.order to speed up sale.report
Impacted modules: sale, sale_margin, sale_timesheet, pos_sale
This speed up a lot reports like sale.report when multiple currencies
with multiple rates are used, even with few currencies and few rates.
Using `_select_companies_rates` in SQL view bring lots of JOINs,
which slow down the view generation. This commit adds a computed
stored field containing the currency rate at the order date to speed
up report generation (database schema denormalisation).
This commit also use this new column on sale.report extensions and on
the project.profitability.report in sale_timesheet module.
Since a4d6bff197b894f70eaecf5aa4e2088e5b014780, the pos.report is
included in the sale.report. So, the same change had to be
applied on the pos.order model.
Task #1877418
Closes #25089
Diffstat (limited to 'addons/mail/static/src')
0 files changed, 0 insertions, 0 deletions
