summaryrefslogtreecommitdiff
path: root/db/096to097.sql
diff options
context:
space:
mode:
authorBrion Vibber <brion@pobox.com>2010-12-17 16:08:37 -0800
committerBrion Vibber <brion@pobox.com>2010-12-17 16:08:37 -0800
commitfb65d5901d586a13886b81d84de8959b67b6aa9e (patch)
tree00cb879e21f055479f997ead9bd2c99404655af7 /db/096to097.sql
parent71151b3bc0e1b1d4d560bf296eb0a572485389e8 (diff)
Update sorting for conversation views: adds notice_conversation_created_id_idx index on notice, replacing more limited notice_conversation_idx
Diffstat (limited to 'db/096to097.sql')
-rw-r--r--db/096to097.sql8
1 files changed, 6 insertions, 2 deletions
diff --git a/db/096to097.sql b/db/096to097.sql
index 5947538da..88cbea457 100644
--- a/db/096to097.sql
+++ b/db/096to097.sql
@@ -1,10 +1,14 @@
-- Add indexes for sorting changes in 0.9.7
--- Allows sorting public timeline and api/statuses/repeats by timestamp efficiently
+-- Allows sorting public timeline, api/statuses/repeats, and conversations by timestamp efficiently
alter table notice
add index notice_created_id_is_local_idx (created,id,is_local),
+
+ add index notice_repeat_of_created_id_idx (repeat_of, created, id),
drop index notice_repeatof_idx,
- add index notice_repeat_of_created_id_idx (repeat_of, created, id);
+
+ add index notice_conversation_created_id_idx (conversation, created, id),
+ drop index notice_conversation_idx;
-- Allows sorting tag-filtered public timeline by timestamp efficiently
alter table notice_tag add index notice_tag_tag_created_notice_id_idx (tag, created, notice_id);