Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2684

Use EXISTS subquery for expressions using to-many related entities

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • 5.0-M2
    • Core Library
    • None

    Description

      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.

      Attachments

        Activity

          People

            ntimofeev Nikita Timofeev
            ntimofeev Nikita Timofeev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: