Cache clear tables
Generally in Pega, How to clear the table caches? Is it servers restart every time mandatory ?
Pegasystems Inc.
US
Hi Pavan,
In order to clear the cache tables data, i would suggest you to reach the GCS team so that they can provide you the specific queries related to your version. The server restart is not mandatory for all the scenarios and it depends on the type of your scenario.
For example, if you had installed any hotfix which has the prerequisite to clear the extractmarker file in order to clear the Lockup List Cache(PegaTempDir) then you need to perform the restart of the JVM in this scenario.
Hope this information might clear your doubt.
Regards
Mahesh
Pegasystems Inc.
IN
Hi,
Truncating cache tables is not something that should be done as part of a standard operating procedure. The main advantage of Caching is to reuse already assembled rules rather than querying out tables and assembling every time they are called. This reduces the time to assemble rules or perform same action again and again. This will improve performance.
Hi,
Truncating cache tables is not something that should be done as part of a standard operating procedure. The main advantage of Caching is to reuse already assembled rules rather than querying out tables and assembling every time they are called. This reduces the time to assemble rules or perform same action again and again. This will improve performance.
The cache will be deleted automatically based on the cache limit set in the DSS or prconfig.
Below are the default limits.
fua/global/instancecountlimit - 20000
fua/personal/instancecountlimit - 20000
collections/mru/PropertyReference/instancecountlimit - 10000
collections/mru/LowerCase/instancecountlimit - 10000
collections/mru/UpperCase/instancecountlimit - 15000
There are Pega OOTB agents like PurgeAssemblyDatabaseCache to purge cache based on the time interval.
However, there are some scenarios where cache needs to be cleared manually like new rules added or modified and are not referenced due to cache or scenarios like RuleNotFoundExceptions are appearing in logs even if the rules are present.
Below links will be helpful too
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
https://pdn.pega.com/performance/performance-guidance-for-production-systems-system-settings
All are related to Cache Management and Performance.