function get($m="", $opts)
{
+ // prune irrelivant stuff..
+
+
+
$this->prune((int)$opts['months']);
}
function prune($inM)
{
// 40 seconds ? to delete 100K records..
- //DB_DataObject::debugLevel(1);
+ // DB_DataObject::debugLevel(1);
$f = DB_DataObject::Factory('reader_article');
$f->query("
DELETE FROM Events where
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 ('NOTIFY')
+ LIMIT 100000
+ ");
+
// pruning is for our press project - so we do not clean up dependant tables at present..
if (function_exists('posix_getpwuid')) {