diff options
| author | Shay <hillerys@element.io> | 2023-05-31 15:13:48 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-05-31 15:13:48 -0700 |
| commit | 6d9e2fd8782a6610d6daf499d141e67f476b2f8c (patch) | |
| tree | 5f4ae23946b48cd88f33bdf96418bd77f8c90e8e | |
| parent | Fix a performance issue introduced in Synapse v1.83.0 which meant that purgin... (diff) | |
| download | synapse-6d9e2fd8782a6610d6daf499d141e67f476b2f8c.tar.xz | |
Speed up background jobs populate_full_user_id_user_filters and populate_full_user_id_profiles (#15700)
| -rw-r--r-- | changelog.d/15700.misc | 1 | ||||
| -rw-r--r-- | synapse/storage/databases/main/filtering.py | 2 | ||||
| -rw-r--r-- | synapse/storage/databases/main/profile.py | 2 |
3 files changed, 3 insertions, 2 deletions
diff --git a/changelog.d/15700.misc b/changelog.d/15700.misc new file mode 100644 index 0000000000..e96bc681aa --- /dev/null +++ b/changelog.d/15700.misc @@ -0,0 +1 @@ +Speed up background jobs `populate_full_user_id_user_filters` and `populate_full_user_id_profiles`. \ No newline at end of file diff --git a/synapse/storage/databases/main/filtering.py b/synapse/storage/databases/main/filtering.py index da31eb44dc..f777777cbf 100644 --- a/synapse/storage/databases/main/filtering.py +++ b/synapse/storage/databases/main/filtering.py @@ -71,7 +71,7 @@ class FilteringWorkerStore(SQLBaseStore): SELECT user_id FROM user_filters WHERE user_id > ? ORDER BY user_id - LIMIT 1 OFFSET 50 + LIMIT 1 OFFSET 1000 """ txn.execute(sql, (lower_bound_id,)) res = txn.fetchone() 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() |