Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-4979

Bad performance when requesting user list in Admin

XMLWordPrintable

      1. Implement pagination for the user list
      2. Validate MyBatis Query

      AT:

      • there exists a new LDAP config property authorizationCheckEnabled
      • default is true
      • if authorizationCheckEnabled is set to false, then the authorization checks are not performed when querying for users and groups

        This is the controller panel for Smart Panels app

            [CAM-4979] Bad performance when requesting user list in Admin

            Roman Smirnov added a comment - - edited

            1. Implement pagination for the user list

            See CAM-5131

            2. Validate MyBatis Query

            • MyBatis caches executed sql fragments during the execution of a command
            • the sql fragment to check the authorization is also cached but cannot be reused (because of existing if-constructs), so that for each performed authorization check MyBatis caches each executed sql fragment -> if during the execution of a command the authorization check is performed 4000 times, then MyBatis caches the authorization check sql fragment 4000 times
            • MyBatis clears the cache when the command is committed (or closed)

            => After clearing the cache the cached sql fragments can be garbage collected.

            Roman Smirnov added a comment - - edited 1. Implement pagination for the user list See CAM-5131 2. Validate MyBatis Query MyBatis caches executed sql fragments during the execution of a command the sql fragment to check the authorization is also cached but cannot be reused (because of existing if-constructs), so that for each performed authorization check MyBatis caches each executed sql fragment -> if during the execution of a command the authorization check is performed 4000 times, then MyBatis caches the authorization check sql fragment 4000 times MyBatis clears the cache when the command is committed (or closed) => After clearing the cache the cached sql fragments can be garbage collected.

            Daniel Meyer added a comment - - edited

            Documentation seems to be missing

            See: http://stage.docs.camunda.org/manual/develop/user-guide/process-engine/identity-service/#configuration-properties-of-the-ldap-plugin

            Daniel Meyer added a comment - - edited Documentation seems to be missing See: http://stage.docs.camunda.org/manual/develop/user-guide/process-engine/identity-service/#configuration-properties-of-the-ldap-plugin

            Roman Smirnov added a comment -

            There exists a separate documentation issue: CAM-5134

            Roman Smirnov added a comment - There exists a separate documentation issue: CAM-5134

              roman.smirnov Roman Smirnov
              matthijs.burke Matthijs
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: