From: Alan Knowles Date: Thu, 4 Oct 2018 04:33:21 +0000 (+0800) Subject: Prune.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a1b74416a73e62543a235281ff65b7b98a6307cc Prune.php --- diff --git a/Prune.php b/Prune.php index 63d5a867..a29eac11 100644 --- a/Prune.php +++ b/Prune.php @@ -46,28 +46,7 @@ class Pman_Core_Prune extends Pman function prune($inM) { - // 40 seconds ? to delete 100K records.. - // DB_DataObject::debugLevel(1); - /* - $f = DB_DataObject::Factory('Events'); - $f->query(" - DELETE FROM Events where - event_when < NOW() - INTERVAL {$inM} MONTH - AND - action != 'NOTIFY' - 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 ('NOTIFY') - LIMIT 100000 - "); - */ + // rather than deleting them all, it's probably best to just delete notify events that occured to often. // eg. when we tried to deliver multiple times without success... /*