vadvs (vadvs) wrote in changelog,
vadvs
vadvs
changelog

[ljcom] r11689: LJSUP-11788: added LIMITs to sub-selects...

Committer: vad
LJSUP-11788: added LIMITs to sub-selects pre-UNION
initial changes made by Kurt
U   trunk/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm
Modified: trunk/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm
===================================================================
--- trunk/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm	2012-04-11 08:29:43 UTC (rev 11688)
+++ trunk/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm	2012-04-11 08:57:33 UTC (rev 11689)
@@ -19,6 +19,7 @@
             statusvis = 'D' AND
             statusvisdate < NOW() -
                 INTERVAL $LJ::AUTO_PURGE_USERS_AFTER DAY
+                   LIMIT $LJ::EXPUNGE_BATCH
     };
 
     unless ($LJ::DISABLED{'expunge_suspended'}) {
@@ -29,6 +30,7 @@
                 statusvis = 'S' AND
                 statusvisdate < NOW() - INTERVAL
                     $LJ::DAYS_BEFORE_EXPUNGE_SUSPENDED DAY
+                        LIMIT $LJ::EXPUNGE_BATCH
         };
     }
 

Tags: ljcom, pm, vad, vadvs
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments