diff options
| author | Scott Ostler <scottbot9000@gmail.com> | 2010-08-23 16:02:41 -0400 |
|---|---|---|
| committer | Scott Ostler <scottbot9000@gmail.com> | 2010-08-23 16:02:41 -0400 |
| commit | 82c08bc3cf6191146f10cc3cba605f5226281243 (patch) | |
| tree | 17db1cddef574314c477165aefc713e841c3608c | |
| parent | b1f97019665fed6c9a2fae4c4269ede1a388c63b (diff) | |
Changed server startup order
| -rw-r--r-- | db/0-create.psql | 5 | ||||
| -rw-r--r-- | src/site.clj | 6 |
2 files changed, 8 insertions, 3 deletions
diff --git a/db/0-create.psql b/db/0-create.psql index 39e2bf3..8676b79 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -52,6 +52,9 @@ CREATE INDEX messages_created_on_idx ON messages (created_on); CREATE INDEX messages_is_image_idx ON messages (is_image); CREATE INDEX messages_user_created_on_idx ON messages (user_id, created_on desc); +-- Used to load recent dumps in a room +CREATE INDEX messages_room_id_created_on_idx ON messages (room_id, created_on desc); + -- Queries to support: -- 1) What messages are tagged x? (ordered by time, popularity) -- 2) What did I tag x? @@ -108,6 +111,8 @@ CREATE TABLE feed_images ( CREATE INDEX feed_images_url_room_idx ON feed_images (image_url, room); CREATE INDEX feed_images_room_message_idx ON feed_images (room, message_id); +CREATE INDEX feed_images_room_message_id_idx ON feed_images (room, message_id) + WHERE message_id IS NULL; CREATE TABLE invalid_feed_images ( image_url text NOT NULL, diff --git a/src/site.clj b/src/site.clj index 92f6eb9..4ed5d29 100644 --- a/src/site.clj +++ b/src/site.clj @@ -1290,12 +1290,12 @@ order by count desc limit ? offset ?") (load-rooms!) (start! reserved-nicks) (def server (start-server (options :port))) -(start! *user-scores*) -(start! *user-info*) (start! *active-mutes*) ; Delay the following to reduce start-load -(Thread/sleep 3000) +(Thread/sleep 15000) +(start! *user-scores*) +(start! *user-info*) (start-user-flusher!) (start-session-pruner!) (start! hall-results) |