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

query internal role authzmember with PostGres regressed after PR4729

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 7.0.0
    • Fix Version/s: 7.0.0
    • Component/s: None
    • Labels:
    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      3
    • Sprint:
      OpenIDM Sprint 7.0-2

      Description

      https://stash.forgerock.org/projects/OPENIDM/repos/openidm/pull-requests/4719/overview reduced the response time for mysql, but with PostGres response time increased(requests time out) for the following request:

      http://localhost:8080/openidm/internal/role/openidm-authorized/authzMembers?_queryFilter=true&_fields=*&_pageSize=50

       

      The test has the following configuration:

      [Stress]

      test_duration = 300

      preload_users = 60

      roles_per_user = 10

      preload_duration = 300

      assignments_per_role = 1

      number_of_roles = 80

      number_of_assignments = 1

      test_concurrency = 30

       

      24999 managed users are preloaded for the query.

      to rerun:

      run-pybot.py -v -c perf -s relationship.QueryManUsersWithRolesManager OpenIDM

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason.vincent jason vincent
                Reporter:
                jenny.zhang Jenny Zhang [X] (Inactive)
                QA Assignee:
                Alexander Dracka
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: