Commit message (Collapse) | Author | Files | Lines | ||
---|---|---|---|---|---|
2021-02-15 | Fix get_users_who_share_room_with_user SQL github/anoa/presence_speedups anoa/presence_speedups | Andrew Morgan | 1 | -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 |