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

sortKeys results in a long query to retrieve managed users when using DS as IDM repository

    Details

    • Support Ticket IDs:

      Description

      If DS is used as IDM repository the sortKey parameters results in a long query to retrieve the managed users.

       

      How to reproduce

      1) Generate 3 000 000 users in DS identity repository

      2) Setup IDM and create an ldap connector and a mapping to the managed users

      3) Sync the data

      4) Go to the managed users in IDM and wait until the users are loaded

      This takes a long time.

      5) Do the REST call without the sortKeys parameter and you will get a response in a couple of ms.

       

      Curl with sortKeys

      curl --location --request GET 'http://idm.local:8080/openidm/managed/user?_queryFilter=true&_pageSize=50&_sortKeys=userName&_totalPagedResultsPolicy=ESTIMATE&_fields=' \
      --header 'Content-Type: application/json' \
      --header 'Accept: application/json, text/javascript, */*; q=0.01' \
      --header 'Accept-Encoding: gzip, deflate' \
      --header 'Accept-Language: en-gb' \
      --header 'Cache-Control: no-cache' \
      --header 'X-OpenIDM-Username: openidm-admin' \
      --header 'X-OpenIDM-Password: openidm-admin'

       

      Curl without sortKeys

      curl --location --request GET 'http://idm.local:8080/openidm/managed/user?_queryFilter=true&_pageSize=50&_totalPagedResultsPolicy=ESTIMATE&_fields=' \
      --header 'Content-Type: application/json' \
      --header 'Accept: application/json, text/javascript, */*; q=0.01' \
      --header 'Accept-Encoding: gzip, deflate' \
      --header 'Accept-Language: en-gb' \
      --header 'Cache-Control: no-cache' \
      --header 'X-OpenIDM-Username: openidm-admin' \
      --header 'X-OpenIDM-Password: openidm-admin'

       

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brmiller Brendan Miller
                Reporter:
                jelle.v Jelle Verbraak
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: