diff options
Diffstat (limited to 'db/096to097.sql')
-rw-r--r-- | db/096to097.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/db/096to097.sql b/db/096to097.sql index 53f4e97c9..38e4e958b 100644 --- a/db/096to097.sql +++ b/db/096to097.sql @@ -1,3 +1,7 @@ -- 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 tag-filtered public timeline by timestamp efficiently +alter table notice_tag add index notice_tag_tag_created_notice_id_idx (tag, created, notice_id); |