From b1f97019665fed6c9a2fae4c4269ede1a388c63b Mon Sep 17 00:00:00 2001 From: Scott Ostler Date: Mon, 23 Aug 2010 16:02:12 -0400 Subject: Changed scores and directory update freq, add msgs index to 0-create.psql, change server startup order --- src/site.clj | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) (limited to 'src') diff --git a/src/site.clj b/src/site.clj index 731e196..92f6eb9 100644 --- a/src/site.clj +++ b/src/site.clj @@ -340,9 +340,7 @@ ORDER BY cnt DESC (def *user-info-query* " SELECT u.nick, u.user_id, - u.avatar, - LAST.content, - LAST.message_id + u.avatar FROM users u LEFT JOIN messages LAST ON u.user_id = LAST.user_id @@ -363,8 +361,8 @@ FROM users u {:list res :map (zipmap (map :nick res) (map :cnt res))})) -(def *scores-refresh-period-sec* (* 30 60)) -(def *user-info-refresh-period-sec* 300) +(def *scores-refresh-period-sec* (* 29 60)) +(def *user-info-refresh-period-sec* (* 31 60)) (def *user-scores* (scheduled-agent build-score-list @@ -523,7 +521,7 @@ FROM users u profile-nick (:nick user-info) ; Update to get right casing nick (session :nick) logger (make-time-logger) - has-avatar (non-empty-string? (user-info :avatar)) + has-avatar (non-empty-string? (:avatar user-info)) offset (maybe-parse-int offset 0) dump-offset (* offset *dumps-per-page*) raw-dumps (logger tags/fetch-dumps-by-nick -- cgit v1.2.3-70-g09d2