You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Nikita Timofeev (Jira)" <ji...@apache.org> on 2020/10/09 13:56:00 UTC

[jira] [Created] (CAY-2684) Use EXISTS subquery for expressions using to-many related entities

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)