summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2017-12-31 11:10:07 +0100
committerYorhel <git@yorhel.nl>2017-12-31 11:10:09 +0100
commit730b7ebbd1ca5a87fa5fc4532e8405edd4d4d1d3 (patch)
treeeef5c11d14c0915f13ef368c8cb207bbf80175d9 /lib
parent81968433973702c0ec38711a48f7b0c3e664f7cb (diff)
Multi::Maintenance: Update cron timings
The database has grown and we're on SSDs now, so it's good to revisit these timings and see what needs optimizing, if anything.
Diffstat (limited to 'lib')
-rw-r--r--lib/Multi/Maintenance.pm8
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/Multi/Maintenance.pm b/lib/Multi/Maintenance.pm
index dfa708d6..738909a9 100644
--- a/lib/Multi/Maintenance.pm
+++ b/lib/Multi/Maintenance.pm
@@ -64,16 +64,16 @@ my %dailies = (
AND r.released <= TO_CHAR(NOW(), 'YYYYMMDD')::integer
) AS r(id)|,
- # takes about 9 seconds max, still OK
+ # takes about 15 seconds max, still OK
tagcache => 'SELECT tag_vn_calc()',
- # takes about 90 seconds, might want to optimize or split up
+ # takes about 25 seconds, OK
traitcache => 'SELECT traits_chars_calc()',
- # takes about 30 seconds
+ # takes about 140 seconds, not really OK
vnpopularity => 'SELECT update_vnpopularity()',
- # takes about 1 second, can be performed in ranges as well when necessary
+ # takes about 3 seconds, can be performed in ranges as well when necessary
vnrating => q|
UPDATE vn SET
c_rating = (SELECT (