Cleaning up CacheStream Global
Hi there have been various posts around how to clean up globals without parent data but none have gone into how you solve these issues.
Our database is approaching 600gb in size so i am looking into how to reduce this.
We use standard purge tasks.
Our cache stream class has a global size of 2463243 from running global size so it is what i would like to tackle first.
1) is there any way i can find based on my oldest message session for where most of these globals
2) in the class where these are created what can be done to ensure purping. Basically we have
it seems to store
^CacheStream
^CacheStream(1)
^CacheStren (1,0-3)
^CacheStream(2)
ect.
Product version: Caché 2017.1