X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=Prune.php;h=d827318ca341bb257eea7acc8b2befc81af03c5a;hb=3e1ee3c50fe0b4676c8a68afda93382dfea6eb5a;hp=c5ac9bd415b698391d4757dded4982e583937587;hpb=d5f78ff670dde54e8e69cdb4008bd8f0e87a8054;p=Pman.Core

diff --git a/Prune.php b/Prune.php
index c5ac9bd4..d827318c 100644
--- a/Prune.php
+++ b/Prune.php
@@ -69,6 +69,11 @@ class Pman_Core_Prune extends Pman
         */
         // 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...
+        /*
+         *
+         SELECT on_id, on_table, min(id) as min_id, max(id) as max_id, count(*) as mm FROM Events
+         WHERE action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK GROUP BY  on_id, on_table HAVING  mm > 2 ORDER BY mm desc;
+         */
         
         //DB_DataObject::debugLevel(1);
         $f = DB_DataObject::Factory('Events');
@@ -78,7 +83,7 @@ class Pman_Core_Prune extends Pman
         $f->groupBy('on_id, on_table');
         $f->having("mm > 2");
         $f->orderBy('mm desc') ;
-        $f->limit(1000);
+        $f->limit(10000);
         $ar = $f->fetchAll();
         foreach($ar as $f) {
             $q = DB_DataObject::Factory('Events');