From 1d76e4bacb547ffee495305140f03dbbe54fb0c5 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 14 Nov 2014 11:39:48 +0800 Subject: [PATCH] Prune.php --- Prune.php | 20 ++++++++++++-------- 1 file changed, 12 insertions(+), 8 deletions(-) diff --git a/Prune.php b/Prune.php index da83a428..a8f65a3f 100644 --- a/Prune.php +++ b/Prune.php @@ -38,14 +38,7 @@ class Pman_Core_Prune extends Pman { // prune irrelivant stuff.. - $f = DB_DataObject::Factory('reader_article'); - $f->query(" - DELETE FROM Events where - event_when < NOW() - INTERVAL 6 MONTH - AND - action IN ('RELOAD', 'LOGIN') - LIMIT 100000 - "); + $this->prune((int)$opts['months']); @@ -61,6 +54,17 @@ class Pman_Core_Prune extends Pman event_when < NOW() - INTERVAL {$inM} MONTH LIMIT 100000 "); + + // notificication events occur alot - so we should trash them more frequently.. + $f = DB_DataObject::Factory('reader_article'); + $f->query(" + DELETE FROM Events where + event_when < NOW() - INTERVAL 1 MONTH + AND + action IN ('RELOAD', 'LOGIN') + LIMIT 100000 + "); + // pruning is for our press project - so we do not clean up dependant tables at present.. if (function_exists('posix_getpwuid')) { -- 2.39.2