diff options
| -rwxr-xr-x | script/clear-caches | 2 | ||||
| -rwxr-xr-x | script/fill-database-caches | 11 |
2 files changed, 12 insertions, 1 deletions
diff --git a/script/clear-caches b/script/clear-caches index 01ea95edc..63e9a979d 100755 --- a/script/clear-caches +++ b/script/clear-caches @@ -4,7 +4,7 @@ LOC=`dirname $0` -$LOC/runner "ActiveRecord::Base.connection.execute(\"update incoming_messages set cached_attachment_text_clipped = null, cached_main_body_text = null\")" +$LOC/runner "ActiveRecord::Base.connection.execute(\"update incoming_messages set cached_attachment_text_clipped = null, cached_main_body_text_unfolded = null, cached_main_body_text_folded = null\")" # Remove page cache (do it in two stages so live site gets cache cleared faster) rm -fr $LOC/../old-cache diff --git a/script/fill-database-caches b/script/fill-database-caches new file mode 100755 index 000000000..306b22ff2 --- /dev/null +++ b/script/fill-database-caches @@ -0,0 +1,11 @@ +#!/bin/bash + +# Fill in all the database caches of text from body/attachments. +# Will take a while to run! Can use after clear-caches to refresh the database +# level caches if you like. + +LOC=`dirname $0` + +$LOC/runner 'IncomingMessage.find_each() { |im| print im.id.to_s + " id: main body folded:" + im.get_main_body_text_folded.size.to_s + " attachment clipped:" + im.get_attachment_text_clipped.size.to_s + "\n" }' + + |