Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-39254

refreshAuthzGroup is inefficient and can cause high load

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: 11.0
    • Component/s: Kernel
    • Labels:
    • Previous Issue Keys:
      KNL-1325

      Description

      The method in DbAuthzGroupService.refreshAuthzGroup() can add a lot of pressure to a database especially for systems that use course management api to maintain enrollment information.

      KNL-1304 would have refreshing authz groups be disabled which would cause other issues with realms that have been updated but not used.

      There is another approach first fostered by John Bush and later improved upon which is to make refreshAuthzGroups to be more efficient and reduce the load on a database. This has been in production for Asahi Net clients for a while and we have had good success with it even with sakai system that has 14K active sessions.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  ern Earle R Nietzel
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration