summary refs log tree commit diff
path: root/synapse/storage/databases/main
diff options
context:
space:
mode:
authorShay <hillerys@element.io>2022-07-18 13:15:23 -0700
committerGitHub <noreply@github.com>2022-07-18 13:15:23 -0700
commit7864f33e286dec22368dc0b11c06eebb1462a51e (patch)
tree3c409de31f951e71cdcde519511f4708d48c45ca /synapse/storage/databases/main
parentImprove performance of query ` _get_subset_users_in_room_with_profiles` (#13299) (diff)
downloadsynapse-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.py1
-rw-r--r--synapse/storage/databases/main/roommember.py2
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",
         )