diff options
author | Yorhel <git@yorhel.nl> | 2017-12-31 11:10:07 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2017-12-31 11:10:09 +0100 |
commit | 730b7ebbd1ca5a87fa5fc4532e8405edd4d4d1d3 (patch) | |
tree | eef5c11d14c0915f13ef368c8cb207bbf80175d9 /lib | |
parent | 81968433973702c0ec38711a48f7b0c3e664f7cb (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.pm | 8 |
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 ( |