Cédric Krier pushed to branch branch/default at Tryton / Tryton
Commits: ee8a99c6 by Cédric Krier at 2022-12-30T13:59:04+01:00 Add index on id and lift It can be used by the database to optimize the search of rules. Closes #11843 - - - - - 1 changed file: - modules/sale_product_recommendation_association_rule/sale.py Changes: ===================================== modules/sale_product_recommendation_association_rule/sale.py ===================================== @@ -129,11 +129,16 @@ def __setup__(cls): super().__setup__() t = cls.__table__() - cls._sql_indexes.add( - Index( - t, - (t.lift, Index.Range(order='DESC')), - (t.conviction, Index.Range(order='ASC')))) + cls._sql_indexes.update({ + Index( + t, + (t.lift, Index.Range(order='DESC')), + (t.conviction, Index.Range(order='ASC'))), + Index( + t, + (t.id, Index.Range()), + (t.lift, Index.Range(order='DESC'))), + }) def get_product_names(self, name): return ', '.join( View it on Heptapod: https://foss.heptapod.net/tryton/tryton/-/commit/ee8a99c6b9e222de154007ca3d511d127fe713b0 -- View it on Heptapod: https://foss.heptapod.net/tryton/tryton/-/commit/ee8a99c6b9e222de154007ca3d511d127fe713b0 You're receiving this email because of your account on foss.heptapod.net.