Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-15019

[GSS](7.1.z) HHH-12740 Subselect fetching doesn't work when multiLoad was used

XMLWordPrintable

      Given some entities loaded into the session via MultiIdentifierLoadAccess.multiLoad() in one batch via a query using an in-clause. These entities have lazy-fetched OneToMany associations annotated with FetchMode.SUBSELECT.
      When accessing these associations, they will be fetched using one query per parent entity, just as if the parent entities had been loaded one by one.
      This creates serious performance issues when using multiLoad as a replacement for directly querying multiple IDs, which we did do utilize 1st level cache.

            gbadner@redhat.com Gail Badner (Inactive)
            rhn-support-toross Tom Ross
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: