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

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
         };
     }