Discourse/discourse
Discourse/discourse
0
0
Fork 0
mirror of https://gh.wpcy.net/https://github.com/discourse/discourse.git synced 2026-05-10 08:31:14 +08:00
Code Packages Activity Actions
discourse/plugins
History
Exact
Régis Hanol 8f8d88afac
PERF: Optimize query for finding users with unread chat messages (#29964) 
Using CTEs and DISTINCT ON to:
- Pre-filter active users with correct preferences
- Get only first unread message per channel
- Eliminate redundant joins and message scanning

This reduces the query execution time by limiting message scanning and joins to only relevant users and messages.

Internal ref t/142836 & t/139517
2024-11-28 15:28:37 +01:00
..
automation FIX: TopicTagsChanged trigger not working with multiple tags (#29961) 2024-11-27 14:16:29 -03:00
chat PERF: Optimize query for finding users with unread chat messages (#29964) 2024-11-28 15:28:37 +01:00
checklist DEV: Consolidate i18n import paths (#29804) 2024-11-19 20:45:18 +00:00
discourse-details DEV: Consolidate i18n import paths (#29804) 2024-11-19 20:45:18 +00:00
discourse-lazy-videos Update translations (#28577) 2024-08-29 15:37:52 -04:00
discourse-local-dates DEV: Fix no-loose-assertions lint (#29965) 2024-11-28 11:22:27 +01:00
discourse-narrative-bot Update translations (#29212) 2024-10-16 17:52:01 +09:00
discourse-presence DEV: Bump @discourse/lint-configs and autofix (#29847) 2024-11-20 14:15:04 +00:00
footnote UX: fix footnote causing horizontal scroll on narrow screens (#29328) 2024-10-22 05:09:34 +02:00
poll DEV: Fix no-loose-assertions lint (#29965) 2024-11-28 11:22:27 +01:00
spoiler-alert DEV: Consolidate i18n import paths (#29804) 2024-11-19 20:45:18 +00:00
styleguide FIX: Tooltip styleguide triggers not rendering options (#29926) 2024-11-25 16:00:52 -06:00