about summary refs log tree commit diff
path: root/config/database.yml
diff options
context:
space:
mode:
authorAkihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>2018-05-14 19:50:45 +0900
committerEugen Rochko <eugen@zeonfederated.com>2018-05-14 12:50:45 +0200
commit42a1231245410a74435db0342047a991e4c92109 (patch)
tree45f1c0518a09a77215cab601ffdfc40dd803ff92 /config/database.yml
parent416f6445050b662fb15045185332e1dc3bec3694 (diff)
Improve index on statuses for api/v1/accounts account_id statuses (#7476)
Queries with the combination of account_id, id, and visibility can be
categorized in three types:
1. Querying for public and unlisted to enumerate statuses visible to
anyone.
2. Querying for public, unlisted, and private to enumerate statuses
visible to follower.
3. Querying for direct to enumerate own direct statuses.

1 and 2 is covered by the index with condition 'visibility IN (0, 1, 2)'.
It would bring better performance in case that there are many direct
statuses.

The index with condition 'visibility = 3' is just for 3. It would be much
faster to query direct statuses thanks to this query.

The total size of those two indexes are expected to be smaller than the
deleted one because they are partial and does not have to cover all the
table.
Diffstat (limited to 'config/database.yml')
0 files changed, 0 insertions, 0 deletions