Fix N+1 query and add composite index for chat message loading

Performancekamo-shared-library
Ya
12 Machi 2026, 02:19 UTC
Mwandishi
Kamo
Ahadi ya
1a59c06

- Add LEFT JOIN FETCH m.msg to both repository queries to eagerly load MediaObjMsg in the same query, eliminating up to 100 extra SQL queries per chat window open - Add composite index (SESSION_ID, IS_REMOVED, DATE_CREATED) to cover the message fetch query pattern in a single efficient index scan

Mabadiliko yote

Je, unaona nini kuhusu usafiri?

Kila moja ya hizi updates ardhi katika nafasi yako ya kazi moja kwa moja. Kuanza bure na kuangalia kukua wiki baada ya wiki.

Kuwa Huru MileleMtazamo wa bei