about summary refs log tree commit diff
diff options
context:
space:
mode:
authorabcang <abcang1015@gmail.com>2019-09-17 15:44:25 +0900
committerEugen Rochko <eugen@zeonfederated.com>2019-09-17 08:44:25 +0200
commitc21386cff5ff6d86d8887e4a5dde1cf910ab84a0 (patch)
tree62878b48e245c2aaad4857958ccf081157e888ed
parent3d14b8f28f96eb4da352f615ee5b9c06ecdcc269 (diff)
Improve IP cleanup query (#11871)
-rw-r--r--app/workers/scheduler/ip_cleanup_scheduler.rb4
1 files changed, 2 insertions, 2 deletions
diff --git a/app/workers/scheduler/ip_cleanup_scheduler.rb b/app/workers/scheduler/ip_cleanup_scheduler.rb
index 42620332e..4f44078d8 100644
--- a/app/workers/scheduler/ip_cleanup_scheduler.rb
+++ b/app/workers/scheduler/ip_cleanup_scheduler.rb
@@ -9,7 +9,7 @@ class Scheduler::IpCleanupScheduler
 
   def perform
     time_ago = RETENTION_PERIOD.ago
-    SessionActivation.where('updated_at < ?', time_ago).destroy_all
-    User.where('last_sign_in_at < ?', time_ago).update_all(last_sign_in_ip: nil)
+    SessionActivation.where('updated_at < ?', time_ago).in_batches.destroy_all
+    User.where('last_sign_in_at < ?', time_ago).where.not(last_sign_in_ip: nil).in_batches.update_all(last_sign_in_ip: nil)
   end
 end