Question
Highmark Health Solutions INC
US
Last activity: 12 Feb 2019 0:37 EST
Pega Clear Cache FROM DB
Hi all, we recently upgraded our app from Pega 7.1.8 to Pega 8.1 and post upgrade we skimmed the rules and did all application validations and rule revalidations. now that when we start running the app for validating the compliance changes to be done we see a lot of slowness in the system.
I remember we had this issue in 7.1.8 and when we had that slow one of the article in PDN suggested to truncate the following cache tables which has improved the system performance. am thinking to do the same for 8.1 but not sure if the tables still remain same or is there any addition to the list for 8.1
|
pr_sys_app_hierarchy_flat; |
|
pr_sys_app_ruleset_index; |
|
pr_sys_class_ancestors; |
|
pr_assembledclasses; |
|
pr4_rule_sysgen; |
|
pr_sys_appcache_entry; |
|
pr_sys_appcache_dep; |
|
pr_sys_appcache_shortcut; |
|
pr_sys_cache_dep; |
|
pr_sys_cache_entry; |
Hi all, we recently upgraded our app from Pega 7.1.8 to Pega 8.1 and post upgrade we skimmed the rules and did all application validations and rule revalidations. now that when we start running the app for validating the compliance changes to be done we see a lot of slowness in the system.
I remember we had this issue in 7.1.8 and when we had that slow one of the article in PDN suggested to truncate the following cache tables which has improved the system performance. am thinking to do the same for 8.1 but not sure if the tables still remain same or is there any addition to the list for 8.1
|
pr_sys_app_hierarchy_flat; |
|
pr_sys_app_ruleset_index; |
|
pr_sys_class_ancestors; |
|
pr_assembledclasses; |
|
pr4_rule_sysgen; |
|
pr_sys_appcache_entry; |
|
pr_sys_appcache_dep; |
|
pr_sys_appcache_shortcut; |
|
pr_sys_cache_dep; |
|
pr_sys_cache_entry; |
|
pr_sys_cache_impl; |
|
pr_sys_cache_dep; |
***Edited by Moderator: Pallavi to update platform capability tags***
Accepted Solution
British Telecom
IN
additionally below link gives information on each tables listed above.
Accepted Solution
British Telecom
IN
additionally below link gives information on each tables listed above.
Highmark Health Solutions INC
US
Thanks a lot @Manju_GCS