diff options
| author | Eric Eastwood <erice@element.io> | 2023-06-07 11:47:01 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-06-07 11:47:01 -0500 |
| commit | e536f02f68135a8494f80ded75d1a53b98cbcb8d (patch) | |
| tree | 05b27334784f872f2ec0b79e726a9c3fe88c2b37 | |
| parent | Remove redundant `room_memberships` join to find participating servers in a r... (diff) | |
| download | synapse-e536f02f68135a8494f80ded75d1a53b98cbcb8d.tar.xz | |
Remove superfluous `room_memberships` join from background update (#15733)
Spawning from https://github.com/matrix-org/synapse/pull/15731
| -rw-r--r-- | changelog.d/15733.misc | 1 | ||||
| -rw-r--r-- | synapse/storage/databases/main/roommember.py | 1 |
2 files changed, 1 insertions, 1 deletions
diff --git a/changelog.d/15733.misc b/changelog.d/15733.misc new file mode 100644 index 0000000000..3ae7be3c27 --- /dev/null +++ b/changelog.d/15733.misc @@ -0,0 +1 @@ +Remove superfluous `room_memberships` join from background update. diff --git a/synapse/storage/databases/main/roommember.py b/synapse/storage/databases/main/roommember.py index 1b8ec67f54..582875c91a 100644 --- a/synapse/storage/databases/main/roommember.py +++ b/synapse/storage/databases/main/roommember.py @@ -1460,7 +1460,6 @@ class RoomMemberBackgroundUpdateStore(SQLBaseStore): SELECT stream_ordering, event_id, events.room_id, event_json.json FROM events INNER JOIN event_json USING (event_id) - INNER JOIN room_memberships USING (event_id) WHERE ? <= stream_ordering AND stream_ordering < ? AND type = 'm.room.member' ORDER BY stream_ordering DESC |