diff options
| author | Shay <hillerys@element.io> | 2022-07-18 13:15:23 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-07-18 13:15:23 -0700 |
| commit | 7864f33e286dec22368dc0b11c06eebb1462a51e (patch) | |
| tree | 3c409de31f951e71cdcde519511f4708d48c45ca /synapse/storage/databases/main | |
| parent | Improve performance of query ` _get_subset_users_in_room_with_profiles` (#13299) (diff) | |
| download | synapse-7864f33e286dec22368dc0b11c06eebb1462a51e.tar.xz | |
Increase batch size of `bulk_get_push_rules` and `_get_joined_profiles_from_event_ids`. (#13300)
Diffstat (limited to 'synapse/storage/databases/main')
| -rw-r--r-- | synapse/storage/databases/main/push_rule.py | 1 | ||||
| -rw-r--r-- | synapse/storage/databases/main/roommember.py | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/databases/main/push_rule.py b/synapse/storage/databases/main/push_rule.py index 86649c1e6c..768f95d16c 100644 --- a/synapse/storage/databases/main/push_rule.py +++ b/synapse/storage/databases/main/push_rule.py @@ -228,6 +228,7 @@ class PushRulesWorkerStore( iterable=user_ids, retcols=("*",), desc="bulk_get_push_rules", + batch_size=1000, ) rows.sort(key=lambda row: (-int(row["priority_class"]), -int(row["priority"]))) diff --git a/synapse/storage/databases/main/roommember.py b/synapse/storage/databases/main/roommember.py index 46ab6232d4..df6b82660e 100644 --- a/synapse/storage/databases/main/roommember.py +++ b/synapse/storage/databases/main/roommember.py @@ -904,7 +904,7 @@ class RoomMemberWorkerStore(EventsWorkerStore): iterable=event_ids, retcols=("user_id", "display_name", "avatar_url", "event_id"), keyvalues={"membership": Membership.JOIN}, - batch_size=500, + batch_size=1000, desc="_get_joined_profiles_from_event_ids", ) |