Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-4516

Limit the frequency of updates to cwd_token.last_acccesed_time

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • 2.8.4, 2.9.1
    • None
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      Every time a token is validated, the value of cwd_token.last_accessed_time is updated. This field has a resolution of milliseconds which is very high for most use cases. By reducing the resolution we could reduce the number of times this field is updated and saved to the database.

      This is important because any read-only request (like finding a user) via the REST API is authenticated, and Crowd refreshes the last_accessed_time, which is a write in the database. That means that read operations actually involve at least one write to the database, which is typically more expensive and less scalable.

      Attachments

        Issue Links

          Activity

            People

              osenn Oliver Senn
              dberrueta Diego Berrueta
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: