Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-12235

Backport OPENIDM-11708: Perf regression: Link expanded collection relationships not loading in graph query.

    XMLWordPrintable

Details

    • 3

    Description

      15a3da144 OPENIDM-11480 Remove outer-joined subquery from the relationship big query to support oracle 11

      The above commit causes IDM to load the link expanded collection relationships one-by-one after calling the mega-query.  The mega query should already be providing the data.  

       

      Steps:

      Create 2 users, one being a manager of the other.  (or a user with 2 roles, or a role assigned to 100 users)  The more items in the relationship collection will expose the reads taking place.

      Make a query like

      http://localhost:8080/openidm/managed/user?_queryFilter=_id eq '2c50a5db-4312-4c29-85fe-90b3a0283f3a'&_fields=reports/*
      curl --request GET \
      --url 'http://localhost:8080/openidm/managed/user?_queryFilter=_id%20eq%20%272c50a5db-4312-4c29-85fe-90b3a0283f3a%27&_fields=reports/%2A' \
      --header 'Cache-Control: no-cache' \
      --header 'X-OpenIDM-Password: openidm-admin' \
      --header 'X-OpenIDM-Username: openidm-admin'

       

       Note that the DB will be queried for the report users's data even though the data should be returned in the mega query.

       Set logging level to see SQL - or put debug breakpoint on AugmentationChainFactory#145 - the logic should not reach that line as the referenced vertex fullobject/id should be there.

       

      Attachments

        Issue Links

          Activity

            People

              patrickdiligent patrick diligent
              patrickdiligent patrick diligent
              Jakub Janoska [X] Jakub Janoska [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: