Details
-
Type:
Suggestion
-
Status: Future Consideration (View Workflow)
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: Caching, Directories, Performance
-
Labels:None
-
Feedback 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.