diff options
author | Brion Vibber <brion@pobox.com> | 2010-12-17 15:13:09 -0800 |
---|---|---|
committer | Brion Vibber <brion@pobox.com> | 2010-12-17 15:13:09 -0800 |
commit | 1b90ed564a19dcb3d24d0c0620ce0623773fe4d0 (patch) | |
tree | b84e400ee115c75c2e95b70b206106c98b6d33c3 /db/096to097.sql | |
parent | 04aa8bd70f0c3f84af349b8a801ea73753077760 (diff) |
Update sorting on api/statuses/retweets: adds notice_repeat_of_created_id_idx index to replace notice_repeatof_idx
Diffstat (limited to 'db/096to097.sql')
-rw-r--r-- | db/096to097.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/db/096to097.sql b/db/096to097.sql index c3f1fb425..5947538da 100644 --- a/db/096to097.sql +++ b/db/096to097.sql @@ -1,7 +1,10 @@ -- Add indexes for sorting changes in 0.9.7 --- Allows sorting public timeline by timestamp efficiently -alter table notice add index notice_created_id_is_local_idx (created,id,is_local); +-- Allows sorting public timeline and api/statuses/repeats by timestamp efficiently +alter table notice + add index notice_created_id_is_local_idx (created,id,is_local), + drop index notice_repeatof_idx, + add index notice_repeat_of_created_id_idx (repeat_of, created, id); -- 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); |