phorge-phorge/resources/sql/autopatches/20150514.user.cache.2.sql at master - revi-archive/phorge-phorge - SiliconForest Atelier

revi-archive/phorge-phorge

mirror of https://we.phorge.it/source/phorge.git synced 2024-11-09 16:32:39 +01:00

epriestley aa550189c7 Add an availability cache for users

Summary: Ref T7707. Caches availability on users to reduce the cost of loading handles. This cache is very slightly tricky to dirty properly.

Test Plan:
  - Use DarkConsole to examine queries; saw cache hits, miss+fill, dirty.
  - Saw availability change correctly after canceling, joining, declining events.
  - Saw no queries to Calendar for pages with only availability data.

Reviewers: btrahan

Reviewed By: btrahan

Subscribers: epriestley

Maniphest Tasks: T7707

Differential Revision: https://secure.phabricator.com/D12838

2015-05-14 11:15:22 -07:00

5 lines

174 B

SQL

Raw Permalink Blame History

 ALTER TABLE {$NAMESPACE}_user.user
   ADD availabilityCache VARCHAR(255) COLLATE {$COLLATE_TEXT};
 ALTER TABLE {$NAMESPACE}_user.user
   ADD availabilityCacheTTL INT UNSIGNED;