diff options
author | Evan Prodromou <evan@controlyourself.ca> | 2009-07-09 19:35:50 -0400 |
---|---|---|
committer | Evan Prodromou <evan@controlyourself.ca> | 2009-07-16 00:19:34 -0400 |
commit | da512ad8c2b4cba719204d8a8f42ecba9716702e (patch) | |
tree | 0a1c883cb5a1a819759937bfb829e6bbb03c4d50 /scripts/triminboxes.php | |
parent | c07c4b20502735104cc35d260b4c7f3904a3a9fb (diff) |
gc inboxes on a regular basis
Diffstat (limited to 'scripts/triminboxes.php')
-rw-r--r-- | scripts/triminboxes.php | 40 |
1 files changed, 1 insertions, 39 deletions
diff --git a/scripts/triminboxes.php b/scripts/triminboxes.php index b2135d682..27e200fef 100644 --- a/scripts/triminboxes.php +++ b/scripts/triminboxes.php @@ -52,43 +52,5 @@ if (!empty($id)) { $cnt = $user->find(); while ($user->fetch()) { - - $inbox_entry = new Notice_inbox(); - $inbox_entry->user_id = $user->id; - $inbox_entry->orderBy('created DESC'); - $inbox_entry->limit(1000, 1); - - $id = null; - - if ($inbox_entry->find(true)) { - $id = $inbox_entry->notice_id; - } - - $inbox_entry->free(); - unset($inbox_entry); - - if (is_null($id)) { - continue; - } - - $start = microtime(true); - - $old_inbox = new Notice_inbox(); - $cnt = $old_inbox->query('DELETE from notice_inbox WHERE user_id = ' . $user->id . ' AND notice_id < ' . $id); - $old_inbox->free(); - unset($old_inbox); - - print "Deleted $cnt notices for $user->nickname ($user->id).\n"; - - $finish = microtime(true); - - $delay = 3.0 * ($finish - $start); - - print "Delaying $delay seconds..."; - - // Wait to let slaves catch up - - usleep($delay * 1000000); - - print "DONE.\n"; + Notice_inbox::gc($user->id); } |