summary refs log tree commit diff
path: root/synapse/storage/databases (unfollow)
Commit message (Collapse)AuthorFilesLines
2021-02-15Fix get_users_who_share_room_with_user SQL github/anoa/presence_speedups anoa/presence_speedupsAndrew Morgan1-3/+4
Three fixes here: * Using UNION only selects DISTINCT rows from each query. However, if we DISTINCT the rows during the query, and then use UNION ALL which doesn't attempt to select distinct rows, we get a 1/3rd speedup in query