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
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:12 | roundup-bot | set | messages: + msg63924 |
| 2021-01-17 00:59:04 | roundup-bot | set | messages:
+ msg63923 nosy: + roundup-bot status: testing -> resolved |
| 2020-12-18 13:17:16 | reviewbot | set | messages:
+ msg63364 nosy: + reviewbot |
| 2020-12-18 12:48:39 | ced | set | keyword:
+ review reviews: 343221002 status: in-progress -> testing |
| 2020-12-18 12:47:32 | ced | create | |
Showing 10 items. Show all history (warning: this could be VERY long)