Huge database data from just two tables

[matteo.rossi]

Hi everyone,

I'm trying to upgrade Revive AdServer and I'm stuck due to rv_dj_track_ad_requests and rv_dj_track_ad_responses, that are respectively 25GiB and 6Gib..

Is there a feature to remove data older than specific date? Isn't there an automatic purge routine? And is it safe to remove those data?

Thanks for the support

[andrewatfornax]

From memory, there's no automatic purge, because Revive Adserver cannot safely tell what statistics you want to keep vs. those that you don't want to keep.

I think, though, that if you have expired campaigns that you no longer want the statistics for, then if you delete them, the statistics are also deleted...