Details

    • Type: Improvement Improvement
    • Status: Open Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Database
    • Security Level: Public (Public: Anyone can view)
    • Labels:
    • Similar issues:
      KULRICE-6463New DB Indexes for KIM Permission checks
      KULRICE-97Add paging for large role/group memberships on KIM documents
      KULRICE-4538KIM Group maintenance screens allow creation of circular group memberships
      KULRICE-6299New DB index to improve action list performance
      KULRICE-13135Remove all membership mappings from GroupBo and RoleBo
      KULRICE-2357KIM Group Service Test
      KULRICE-1133Update KIM DB diagram
      KULRICE-4575IM Person doc should only allow editing of direct group memberships
      KULRICE-11043Person document goes into exception when attempting to deactivate a Person with a single group membership
      KULRICE-3578Investigate and possibly create rice db indexes recommended by Colorado State
    • Rice Module:
      KIM
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      The following index can improve performance of group membership checks in KIM:

      CREATE INDEX KRIM_GRP_MBR_TI2 ON KRIM_GRP_MBR_T (GRP_ID);

      It only gives us a minor performance improvement at IU, but it does reduce the cost of a fairly common query from 167 to 3 so it is worth adding to the standard database.

        Activity

        Hide
        Jessica Coltrin (Inactive) added a comment -

        moving to 2.1.2

        Show
        Jessica Coltrin (Inactive) added a comment - moving to 2.1.2
        Hide
        Jessica Coltrin (Inactive) added a comment -

        moving all issues not Blocker or Critical for 2.1.2 to the backlog.

        Show
        Jessica Coltrin (Inactive) added a comment - moving all issues not Blocker or Critical for 2.1.2 to the backlog.

          People

          • Assignee:
            Unassigned
            Reporter:
            James Bennett
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Structure Helper Panel