Nikita Timofeev created CAY-2684: ------------------------------------ Summary: Use EXISTS subquery for expressions using to-many related entities Key: CAY-2684 URL: https://issues.apache.org/jira/browse/CAY-2684 Project: Cayenne Issue Type: Improvement Components: Core Library Reporter: Nikita Timofeev Assignee: Nikita Timofeev Fix For: 4.2.M3
Using EXISTS() subquery instead of the JOIN for expressions using paths on to-many related entities could boost performance significant in some cases. As support for the subqueries already implemented per CAY-2468, this should be relatively easy. -- This message was sent by Atlassian Jira (v8.3.4#803005)