summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorNeil Johnson <neil@fragile.org.uk>2018-05-01 12:12:57 +0100
committerNeil Johnson <neil@fragile.org.uk>2018-05-01 12:12:57 +0100
commitd0857702e8e22b8bd3dae7fc3cd3718da1e94f19 (patch)
tree759c0b3eb8b4fcf9252ca6ba9cc87a724bb4dd97 /synapse/storage/schema/delta
parent10 mins seems more reasonable that every minute (diff)
downloadsynapse-d0857702e8e22b8bd3dae7fc3cd3718da1e94f19.tar.xz
add inidexes based on usage
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/49/add_user_daily_visits.sql8
1 files changed, 2 insertions, 6 deletions
diff --git a/synapse/storage/schema/delta/49/add_user_daily_visits.sql b/synapse/storage/schema/delta/49/add_user_daily_visits.sql
index 11356a97fc..3dd478196f 100644
--- a/synapse/storage/schema/delta/49/add_user_daily_visits.sql
+++ b/synapse/storage/schema/delta/49/add_user_daily_visits.sql
@@ -16,10 +16,6 @@
 
 CREATE TABLE user_daily_visits ( user_id TEXT NOT NULL,
                                  device_id TEXT,
-                                 user_agent TEXT NOT NULL,
                                  timestamp BIGINT NOT NULL );
-
-/* What indexes should I include?
- * Reads are offline so should optimise for writes
- * Need to check if already an entry so user,day
- */
+CREATE INDEX user_daily_visits_uts_idx ON user_daily_visits(user_id, timestamp);
+CREATE INDEX user_daily_visits_ts_idx ON user_daily_visits(timestamp);