From 003267bfcdf97a6b91351bf003d5cea3fd8c3831 Mon Sep 17 00:00:00 2001 From: Eric Eastwood Date: Tue, 6 Jun 2023 22:13:49 -0500 Subject: Remove extra `current_state_events` join --- synapse/storage/databases/main/roommember.py | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) diff --git a/synapse/storage/databases/main/roommember.py b/synapse/storage/databases/main/roommember.py index eddf5ed924..e6782980bf 100644 --- a/synapse/storage/databases/main/roommember.py +++ b/synapse/storage/databases/main/roommember.py @@ -132,11 +132,9 @@ class RoomMemberWorkerStore(EventsWorkerStore, CacheInvalidationWorkerStore): SELECT COUNT(DISTINCT substr(out.user_id, pos+1)) FROM ( SELECT - rm.user_id AS user_id, - instr(rm.user_id, ':') AS pos - FROM room_memberships as rm - INNER JOIN current_state_events as c ON rm.event_id = c.event_id - WHERE c.type = 'm.room.member' + user_id AS user_id, + instr(user_id, ':') AS pos + FROM room_memberships ) as out """ else: -- cgit 1.4.1