Issue 9950

Title
Use CTE for currency rate
Priority
feature
Status
resolved
Nosy list
ced, reviewbot, roundup-bot
Assigned to
ced
Keywords
review

Created on 2020-12-18.12:47:32 by ced, last changed 1 month ago by roundup-bot.

Messages

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
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2020-12-18.12:47:32

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.

History
Date User Action Args
2021-01-17 00:59:12roundup-botsetmessages: + msg63924
2021-01-17 00:59:04roundup-botsetmessages: + msg63923
nosy: + roundup-bot
status: testing -> resolved
2020-12-18 13:17:16reviewbotsetmessages: + msg63364
nosy: + reviewbot
2020-12-18 12:48:39cedsetkeyword: + review
reviews: 343221002
status: in-progress -> testing
2020-12-18 12:47:32cedcreate

Showing 10 items. Show all history (warning: this could be VERY long)