summary refs log tree commit diff
path: root/synapse/storage/databases/main/profile.py
diff options
context:
space:
mode:
authorShay <hillerys@element.io>2023-05-31 15:13:48 -0700
committerGitHub <noreply@github.com>2023-05-31 15:13:48 -0700
commit6d9e2fd8782a6610d6daf499d141e67f476b2f8c (patch)
tree5f4ae23946b48cd88f33bdf96418bd77f8c90e8e /synapse/storage/databases/main/profile.py
parentFix a performance issue introduced in Synapse v1.83.0 which meant that purgin... (diff)
downloadsynapse-6d9e2fd8782a6610d6daf499d141e67f476b2f8c.tar.xz
Speed up background jobs populate_full_user_id_user_filters and populate_full_user_id_profiles (#15700)
Diffstat (limited to 'synapse/storage/databases/main/profile.py')
-rw-r--r--synapse/storage/databases/main/profile.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/databases/main/profile.py b/synapse/storage/databases/main/profile.py
index 65c92bef51..21d54c7a7a 100644
--- a/synapse/storage/databases/main/profile.py
+++ b/synapse/storage/databases/main/profile.py
@@ -65,7 +65,7 @@ class ProfileWorkerStore(SQLBaseStore):
                     SELECT user_id FROM profiles
                     WHERE user_id > ?
                     ORDER BY user_id
-                    LIMIT 1 OFFSET 50
+                    LIMIT 1 OFFSET 1000
                   """
             txn.execute(sql, (lower_bound_id,))
             res = txn.fetchone()