diff options
author | Erik Johnston <erik@matrix.org> | 2022-11-23 14:09:00 +0000 |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-11-23 14:09:00 +0000 |
commit | f38d7d79c8ec5c389c51327737bd517a27826bd6 (patch) | |
tree | 1e1644cc7844a1ec8d886a6e4b661a072ede1178 /changelog.d | |
parent | Add missing type hints to test.util.caches (#14529) (diff) | |
download | synapse-f38d7d79c8ec5c389c51327737bd517a27826bd6.tar.xz |
Add another index to `device_lists_changes_in_room` (#14534)
This helps avoid reading unnecessarily large amounts of data from the table when querying with a set of room IDs.
Diffstat (limited to 'changelog.d')
-rw-r--r-- | changelog.d/14534.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/14534.misc b/changelog.d/14534.misc new file mode 100644 index 0000000000..5fe79042e5 --- /dev/null +++ b/changelog.d/14534.misc @@ -0,0 +1 @@ +Improve DB performance by reducing amount of data that gets read in `device_lists_changes_in_room`. |