Cédric Krier pushed to branch branch/default at Tryton / Tryton
Commits: 2ecc50ec by Cédric Krier at 2024-06-18T20:29:31+02:00 Reuse simple COALESCE expression to filter moves after stock period The expression must be the same as the one in the indexes such that the indexes can be used to directly filter out all the moves before the period. This restores the original expression that was changed by e4431b79e409 for the generic move_date. But by design there can not be any assigned move planned before the closed period. - - - - - 32bdc030 by Cédric Krier at 2024-06-18T20:32:09+02:00 Do not add period query to the union if there is no period There is no cache record without period so there is no need to add the query to the UNION. - - - - - 1b4d72bf by Cédric Krier at 2024-06-18T20:33:41+02:00 Add company to the stock move indexes Almost all the queries on stock move filter by company. - - - - - f06bb8b3 by Cédric Krier at 2024-06-19T12:44:33+02:00 Add location and use product range in stock period cache index The cache is always filtered by location and the product is often filtered with reduced ids. - - - - - ee8f075a by Cédric Krier at 2024-06-19T13:23:57+02:00 Set product range index last for stock move As product clause are reduced ids, they have less chance to be usable than the date which is often a single value. - - - - - 2 changed files: - modules/stock/move.py - modules/stock/period.py View it on Heptapod: https://foss.heptapod.net/tryton/tryton/-/compare/d671e177ab660208812bc96bfd8bc366f85b2012...ee8f075af4861a4ad0c848ca2ab0b0aa49df5674 -- View it on Heptapod: https://foss.heptapod.net/tryton/tryton/-/compare/d671e177ab660208812bc96bfd8bc366f85b2012...ee8f075af4861a4ad0c848ca2ab0b0aa49df5674 You're receiving this email because of your account on foss.heptapod.net.
