We noticed that domains of the kind ['OR, ('a', '=', x), ('b.f1', '=', y)]
that result in an expression of the kind t.a = x OR t.id in (subquery)
could be more optimal if we used an UNION
of the two queries (because postgres can sometimes use an index but in my test even without indexes it's a bit more optimal).
The review implements this on Model.search
.
History | |||
---|---|---|---|
Date | User | Action | Args |
2021-08-13 13:44:07 | nicoe | set | messageid: <1628855047.7218475.NJFPCRY6VOLF7ZIL.issue10658@tryton.org> |
2021-08-13 13:44:07 | nicoe | link | issue10658 messages |
2021-08-13 13:44:07 | nicoe | create |
Showing 10 items. Show all history (warning: this could be VERY long)