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)