diff options
| author | Erik Johnston <erik@matrix.org> | 2015-04-30 18:41:05 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-04-30 18:41:05 +0100 |
| commit | 61d05daab1ab4e00f40195cd0c81a88cdedb9632 (patch) | |
| tree | b17f5846b155554dd0de169cb80d254abf8187b0 /synapse/storage/roommember.py | |
| parent | Add more conditions on JOINs to make postgres go a little faster. (diff) | |
| download | synapse-61d05daab1ab4e00f40195cd0c81a88cdedb9632.tar.xz | |
More join conditions
Diffstat (limited to 'synapse/storage/roommember.py')
| -rw-r--r-- | synapse/storage/roommember.py | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/synapse/storage/roommember.py b/synapse/storage/roommember.py index 2952c62f20..09fb77a194 100644 --- a/synapse/storage/roommember.py +++ b/synapse/storage/roommember.py @@ -154,7 +154,9 @@ class RoomMemberStore(SQLBaseStore): "SELECT m.room_id, m.sender, m.membership" " FROM room_memberships as m" " INNER JOIN current_state_events as c" - " ON m.event_id = c.event_id" + " ON m.event_id = c.event_id " + " AND m.room_id = c.room_id " + " AND m.user_id = c.state_key" " WHERE %s" ) % (where_clause,) @@ -212,7 +214,9 @@ class RoomMemberStore(SQLBaseStore): sql = ( "SELECT m.* FROM room_memberships as m" " INNER JOIN current_state_events as c" - " ON m.event_id = c.event_id AND m.room_id = c.room_id " + " ON m.event_id = c.event_id " + " AND m.room_id = c.room_id " + " AND m.user_id = c.state_key" " WHERE %(where)s" ) % { "where": where_clause, |