Uploaded image for project: 'Crowd'
  1. Crowd
  2. CWD-5385

Adding new cache key for the directory attribute

    XMLWordPrintable

    Details

    • Feedback Policy:

      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

      It will be really helpful to cache the data for the following queries as it has been fired on each user login: 

      select attributes0_.directory_id as directory_id1_17_0_, attributes0_.attribute_value as attribute_value3_17_0_, attributes0_.attribute_name as attribute_name2_0_ from cwd_directory_attribute attributes0_ where attributes0_.directory_id=:1
      
      select allowedope0_.app_dir_mapping_id as app_dir_mapping_id1_3_0_, allowedope0_.operation_type as operation_type2_3_0_ from cwd_app_dir_operation allowedope0_ where allowedope0_.app_dir_mapping_id=:1 
      

      These queries are related with instantiation objects of `Directory` class and using getters on them, such as `getAttributes()`, `getAllowedOperations()` or getDirectoryMappings() on objects of `Application` class.

      The cache should help to reduce the load on the database server side.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            yilinmo Yilin (Inactive)
            Votes:
            8 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated: