kurtado (kurtado) wrote in changelog,
kurtado
kurtado
changelog

[ljcom] r11681: added LIMITs to sub-selects pre-UNION

Committer: kurt
added LIMITs to sub-selects pre-UNION

U   branches/r90.5/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm
Modified: branches/r90.5/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm
===================================================================
--- branches/r90.5/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm	2012-04-06 12:16:23 UTC (rev 11680)
+++ branches/r90.5/cgi-bin/LJ/Worker/UserManage/UsersAutoPurge.pm	2012-04-06 21:52:38 UTC (rev 11681)
@@ -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: kurt, kurtado, ljcom, pm
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