diff options
| author | Erik Johnston <erikj@element.io> | 2024-01-11 13:37:57 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-11 13:37:57 +0000 |
| commit | c43f751013489c7a037312455d4ee2793065ed6c (patch) | |
| tree | 7bf2226f3c9a0db977037a35a7617945966480e9 /.ci | |
| parent | Improve DB performance of calculating badge counts for push. (#16756) (diff) | |
| download | synapse-c43f751013489c7a037312455d4ee2793065ed6c.tar.xz | |
Optimize query for fetching to-device messages in `/sync` (#16805)
The current query supports passing in a list of users, which generates a query using `user_id = ANY(..)`. This is generates a less efficient query plan that is notably slower than a simple `user_id = ?` condition. Note: The new function is mostly a copy and paste and then a simplification of the existing function.
Diffstat (limited to '.ci')
0 files changed, 0 insertions, 0 deletions