Daily updates from Odoo
Wednesday, June 6, 2018
1 change · master
Enhancements to existing features
Sales reporting has been optimized so report speed is less affected by the number of currency rates stored in the system. This should make sales analysis and pricelist filtering faster and more reliable for users working with large datasets.
Original PR description
sale.report speed was highly dependent on the currencies rates number. The date end of a rate was computed on the fly. Now, the date end is stored on the model to avoid on-the-fly computation. Lateral join is used to optimise the subquery and permit the subquery to use main query parameters. pricelist_id use a join instead of left join because the field is mandatory. This makes filters on pricelists faster in sale.report. Description of the issue/feature this PR addresses: Current behavior before PR: Desired behavior after PR is merged: -- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr