Uploaded image for project: 'OpenAM'
  1. OpenAM
  2. OPENAM-11707

The supported script for cts-add-index.txt has references to indexes that are not used in AM 5.x

    Details

    • Target Version/s:
    • Support Ticket IDs:

      Description

      We should better document what the add-cts-index.txt.  There are several indexes that are included here that we recommend not indexing in the cts-indices.ldif file from AM 5.0 so should either include that it could cause performance impact or remove them from the script:

      1. coreTokenString04 should not be indexed as it is used to store the session's latestAccessTimeInMillis.
      2. There are no searches that filter on latestAccessTimeInMillis so index maintenance overheads should be avoided.
      1. coreTokenString05 should not be indexed as it is used to store the session's sessionID.
      2. There are no searches that filter on sessionID so index maintenance overheads should be avoided.
      1. coreTokenString06 should not be indexed as it is used to store the session's sessionHandle.
      2. There are no searches that filter on session handle so index maintenance overheads should be avoided.
      1. coreTokenString11 should not be indexed as it is used to store the session's realm. As the realm values are not
      2. distinct enough, indexing on it would cause a performance bottleneck on writes.
      1. coreTokenString12 should not be indexed as it is used to store the session's creationTime.
      2. There are no searches that filter on creation time so index maintenance overheads should be avoided.
      1. coreTokenInteger06 should not be indexed as it is used to store the session's maxSessionTimeInMinutes.
      2. There are no searches that filter on max session time in minutes so index maintenance overheads should be avoided.
      1. coreTokenInteger07 should not be indexed as it is used to store the session's maxIdleTimeInMinutes.
      2. There are no searches that filter on max idle time in minutes so index maintenance overheads should be avoided.

        Attachments

          Activity

            People

            • Assignee:
              austingene Gene Hirayama
              Reporter:
              tina.roper Tina Roper
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: