Message 69366

Author
nicoe
Date
2021-08-13.13:44:07
Message id
69366

Content

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:07nicoesetmessageid: <1628855047.7218475.NJFPCRY6VOLF7ZIL.issue10658@tryton.org>
2021-08-13 13:44:07nicoelinkissue10658 messages
2021-08-13 13:44:07nicoecreate

Showing 10 items. Show all history (warning: this could be VERY long)