Friday, March 14, 2025
1 change · saas-17.4
Enhancements to existing features
This update improves how Odoo retrieves warehouse information for stock quantity reports. Businesses should see faster report loading in cases with larger warehouse or inventory datasets, without any change to the report’s visible behavior.
Original PR description
In commit b81314b we replaced a join on a case with a join on a boolean expression- however this did not materially increase performance (same order of magnitutde). Instead we should have simply used a valued case expression, which permits an entirely different (and much more optimal) query plan- specifically during sequential scans of the warehouse_cte common table expression. *See PR for further details*