Skip to content
Snippets Groups Projects
  1. May 14, 2018
    • Yamagishi Kazutoshi's avatar
      Add Slovene language (#7475) · 2226d987
      Yamagishi Kazutoshi authored
      2226d987
    • abcang's avatar
      3793e598
    • Akihiko Odaki's avatar
      Improve index on statuses for api/v1/accounts account_id statuses (#7476) · 42a12312
      Akihiko Odaki authored
      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.
      42a12312
  2. May 13, 2018
  3. May 12, 2018
  4. May 11, 2018
  5. May 10, 2018
  6. May 09, 2018
  7. May 08, 2018
  8. May 07, 2018
Loading