We have a UCCX deployment that has ran for approximately 10 years and gone through several upgrades, now it turns on System version: 18.104.22.16801-24
We noticed there are some slowness on our CUIC so we decided to run a Purge on the Historical Database (especially the ccdr table).
We have entries as old as 2009.
We struggled to verify if the purge is actually running (in fact the operation is done pretty slowwwwwwly that we doubted that it's actually running).
We done that through this two commands :
file tail activelog /uccx/log/db/uccxspl.trace
run uccx sql db_cra select min(startdatetime) from contactcalldetail
I noticed that the purge process is very very slow.
trace expression :2017-02-16 07:46:16.000 Purge iteration till: 2009-03-14 16:00:00
trace expression :2017-02-16 07:50:17.000 Purge iteration from: 2009-03-14 16:00:00
trace expression :2017-02-16 07:50:17.000 Purge iteration till: 2009-03-14 17:00:00
trace expression :2017-02-16 07:54:18.000 Purge iteration from: 2009-03-14 17:00:00
it's 4 minutes for 1 hour.
Kindly note that the purge process is NOT function of workload on CCX. Even at midnight where the Contact Center is closed, it also takes 4 minutes for 1 hour of purged data.
And we are planning to purge all data older that 2015.
Let me calculate it would take 1 hour and half to purge data for a day.
It would take 22 days to purge data for one year
It would take 136 days ~ 4-5 months to purge data from 2009 to 2015
I think this is so long.
Is there a way to accelerate this thing ? I find it inappropriate that it may take 5 months to purge CCX data.
Thank you in advance.