Created on 2020-12-18.12:47:32 by ced, last changed 1 month ago by roundup-bot.
New changeset 480d3354bf05 by Cédric Krier in branch 'default': Use CTE for currency rate in reporting queries https://hg.tryton.org/tryton-env/rev/480d3354bf05
New changeset a88e6cd681a7 by Cédric Krier in branch 'default': Use CTE for currency rate in reporting queries https://hg.tryton.org/modules/sale/rev/a88e6cd681a7
In the last patch version for issue9665, I found that I could optimize the query by using a CTE for the currency rate instead of joining against the query directly.
You can find the differences by comparing both query plans: https://explain.dalibo.com/plan/paL vs https://explain.dalibo.com/plan/sgd
As sale reporting is based on the same design, we should get similar improvement by also using a CTE for the currency rate.
|2021-01-17 00:59:12||roundup-bot||set||messages: + msg63924|
nosy: + roundup-bot
status: testing -> resolved
nosy: + reviewbot
status: in-progress -> testing
Showing 10 items. Show all history (warning: this could be VERY long)